Jump to content


  • Posts

  • Joined

  • Last visited

Everything posted by pulpfiction

  1. Its the same procedure in CR 9, but temp tables are messing it up. guess there's no other option other than to rewrite the SP. its gonna get really complex.
  2. Tried to trace where the div open and close. seems like the container div "content_wrap" is closed after the "left_col" and the "welcome_join" and other divs are outside the container div. so they are moved to the bottom <div id="content_wrap"> <div id="left_col"> <div id="nav"> <ul class="nav"> <li class="item1"><a class="first" href= "index.php?src=gendocs&ref=AboutSampleCity&category=Main&PHPSESSID=3c0eea866da0ca0b84527386ee8eaa17">About Sample City</a></li> <li class="item2"><a href="index.php?src=gendocs&ref=AbouttheChamber&category=Main&PHPSESSID=3c0eea866da0ca0b84527386ee8eaa17">About the Chamber</a></li> <li class="item3"><a href="index.php?src=events&category=Events&PHPSESSID=3c0eea866da0ca0b84527386ee8eaa17">Programs & Events</a></li> <li class="item4"><a href="index.php?src=news&persist_cat=1&srctype=lister&newssearch=yes&kw=&PHPSESSID=3c0eea866da0ca0b84527386ee8eaa17">Press Room</a></li> <li class="item5"><a href="index.php?src=gendocs&ref=GovernmentAffairs&category=Main&PHPSESSID=3c0eea866da0ca0b84527386ee8eaa17">Government Affairs</a></li> <li class="item6"><a href="index.php?src=dining&persist_cat=1&srctype=lister&newssearch=yes&kw=&PHPSESSID=3c0eea866da0ca0b84527386ee8eaa17">Dining Guide</a></li> <li class="item7"><a href="index.php?src=nightlife&persist_cat=1&srctype=lister&newssearch=yes&kw=&PHPSESSID=3c0eea866da0ca0b84527386ee8eaa17">Nightlife Guide</a></li> <li class="item8"><a href="index.php?src=directory&view=businesses&view=businesses_lister&PHPSESSID=3c0eea866da0ca0b84527386ee8eaa17">Business Search</a></li> <li class="item9"><a href="index.php?src=products&persist_cat=1&srctype=lister&newssearch=yes&kw=&PHPSESSID=3c0eea866da0ca0b84527386ee8eaa17">Marketplace</a></li> <li class="item10"><a href="index.php?src=forum&PHPSESSID=3c0eea866da0ca0b84527386ee8eaa17">Members Forum</a></li> <li class="item11"><a href="index.php?src=faq&PHPSESSID=3c0eea866da0ca0b84527386ee8eaa17">FAQ</a></li> <li class="item12"><a href="index.php?src=blog&view=blog&PHPSESSID=3c0eea866da0ca0b84527386ee8eaa17">Chamber Blog</a></li> <li class="item13"><a href="index.php?src=gendocs&ref=AdvertisingInformation&category=Main&PHPSESSID=3c0eea866da0ca0b84527386ee8eaa17">Advertising Information</a></li> <li class="item14"><a class="last" href="index.php?src=forms&ref=Contact Us&PHPSESSID=3c0eea866da0ca0b84527386ee8eaa17">Contact</a></li> </ul> </div> <!-- END OF NAV --> <div id="poll"> <form action="index.php" method="post" style="margin-bottom:3;"><input type="hidden" name="PHPSESSID" value="3c0eea866da0ca0b84527386ee8eaa17" /> <div class="pollHomeQuestion">What is your favorite thing about Sample City?</div> <div class="pollHomeChoices"><input type="radio" name="myvote" value="1">The People</div> <div class="pollHomeChoices"><input type="radio" name="myvote" value="2">The Nightlife</div> <div class="pollHomeChoices"><input type="radio" name="myvote" value="3">The Events</div> <input type="hidden" name="id" value="1" /> <input type="hidden" name="src" value="poll" /> <input type="hidden" name="srctype" value="process" /> <input type="hidden" name="category" value="Polls" /> <div class="pollHomeVote"> <input type="image" src="http://www.samplechamber.com/graphics/vote.gif" border="0" name="vote" value="Vote" /> </div> </form> </div> <!-- END OF POLL --> <div id="banner"><p align="center"><a class="fba_links" href="index.php?src=fba&srctype=click&id=1&PHPSESSID=3c0eea866da0ca0b84527386ee8eaa17" onclick="window.open(this.href); return false;"><img src="cache/sql/fba/fs_1.jpg" style="border:0px;width:120px;height:90px" alt="Indy Star" /></a></p></div> </div> <!-- END OF LEFT_COL --></div> <!-- END OF CONTENT_WRAP --><!-- THIS DIV ABOVE MUST COME AFTER AT THE BOTTOM, JUST BEFORE THE FOOTER DIV --><!-- ======== Header Page Layout Ends ========= --><div id="welcomejoin">
  3. Never thought of that situation. thanks for correcting.
  4. Are you looking for alternating color for the table rows. Try this........next%></tr><%dim countcount = 1%><%do until rs.EOF%><tr <% if count mod 2 = 0 then %> bgcolor="#f0f0f0" <% else %> bgcolor="#696969" <% end if %>><form method="post" action="demo_db_edit.asp" target="_blank"><%for each x in rs.Fields if x.name="no" then%> <td><input type="submit" name="no" value="<%=x.value%>"></td> <%else%> <td><%Response.Write(x.value)%> </td> <%end ifnext%></form><%count = count + 1rs.MoveNext%></tr>
  5. For this to happen you must call the set of code used to initially populate the datagrid.Say you have a function to populate the datagrid. Populate(). when the new record is inserted then after doing the database insertion again call Populate() and your grid will show all the records including the latest inserted one.
  6. I use VS 2003 and CR bundled with it. When I add a SP, it appears under "database fields" this SP must be expandable and must show the fields to drag into the report. but its not expandable at all. no [+] appears when SP is added. Also SP ends like SELECT fldname from #temp. Data from different tables are collected in a temp table.
  7. After 2 weeks of struggling with CR finally found the work around. its to totally avoid dataset. you need to directly connect with the database [OLE DB]and pull the stored procedure. and add some CR connection info code. Next problem is, one of the stored procedures has temporary table and final data comes from a temp data. CR cannot use that SP. any suggestions? thanks.
  8. Nice idea, worked fine. thanks.
  9. Change #center to code below, you can avoid few lines of code. you can completly remove margin, I put that to get some space between divs. #center { width: 168px; height: 30px; float: left; line-height: 20px; border:1px solid #000; }
  10. When I copy the text from a CODEBOX and paste in a text editor [to test the code], the line breaks doesnt work properly..... its pasted as a chunk of text, not with line breaks but just tab spaces. it gets really tough to go in and seperate the end of line. guess its nothing to do with the text editor [i use notepad++]. does this happen for anyone else? is there any workaround for this?
  11. Im not sure why you have positioning the divs.... try this code below. it puts the divs in place in IE 6, not sure if it would affect othre parts of code.PS: remove borders later, put it on to diffenentiate divs. #container { width: 500px; margin: 0px auto; position: static; padding: 10px 10px 5px 10px; text-align: center; border:1px solid #000;}#left { width: 163px; height: 30px; float: left; line-height: 20px; border:1px solid #000;}#center { width: 163px; height: 30px; float: left; margin:0px 5px; line-height: 20px; border:1px solid #000;}#right { width: 163px; height: 30px; float:left; line-height: 20px; border:1px solid #000;}
  12. Try this... it will get the last but one record. SELECT * FROM tblName WHERE (newsID = (SELECT TOP 1 newsID FROM tblName ORDER BY newsID DESC) - 1)
  13. Try this...http://www.mvps.org/access/queries/qry0011.htmhttp://databases.aspfaq.com/database/how-d...dom-record.html
  14. pulpfiction

    Email form

    I have never used gmail to send mails... guess it takes a little more than just mentioning the smtp server. check this out.http://www.codeproject.com/useritems/SendM...mailAccount.asp
  15. window.open('hammer.html', 'window_name', 'width = 300,height = 250,resizable=0');For more info...http://www.javascripter.net/faq/openinga.htm
  16. pulpfiction

    Email form

    Add this code and remove your subroutine script.... <script runat="server"> private Sub doEmail(sender As Object, e As System.Web.UI.ImageClickEventArgs)Dim sMsg as StringsMsg+="Name :" & txtName.Text & vbcrlfsMsg+="Email :" & txtEmail.Text & vbcrlfDim objEmail as New MailMessage objEmail.To=logan_young@hotmail.com objEmail.From=txtEmail.Text objEmail.Subject=txtSub.Text objEmail.Body=sMsg objEmail.BodyFormat = MailFormat.Text SmtpMail.SmtpServer ="smtp.gmail.com SmtpMail.Send(objEmail) End Sub </script>
  17. pulpfiction

    Email form

    Try using "OnClick"<td width="10%" align="right"> </td> <td colspan="2"><asp:ImageButton id="btnSend" runat="server" OnClick="doEmail" ImageUrl="Images/submit.gif" />
  18. What database are you using? say for example if its SQL Server you can get the records from the database in random order using SQL query.SELECT * FROM tablename ORDER BY NEWID( )This query will return records in random order everytime.
  19. Try this... string str = @"51,5100";char[] charsToTrim = {'0'};str = str.TrimEnd(charsToTrim);Response.Write(str);
  20. Are you sure you wanna do that, cos it will change the value of the number. anyways here's way to remove the trailing zeros in decimal number by checking if its a zero or not. so a small modification to this can help your case...http://database.ittoolbox.com/documents/po...rchar-data-2578
  21. Oh ok, think I understand the problem, its the ASP variable, when you assign a text like that to a variable. then the end of string will be an issue..... one way to handle this is to replace all the double quotes with single quote as soon as you get the string from the file, even before you assign the string to a variable.
  22. Did you try writing the code in <textarea>. it might be easier. Try this. <textarea rows="4" cols="100"><object width="425" height="350"><param name="movie" value="http://www.youtube.com/v/aOJs_3SvsmM"></param><param name="wmode" value="transparent"></param><embed src="http://www.youtube.com/v/aOJs_3SvsmM" type="application/x-shockwave-flash" wmode="transparent" width="425" height="350"></embed></object></textarea> guess another option is to replace < with <. then it will display the HTML code.
  23. Are they gonna release some kinda stats based on this survey in future??
  24. Thats the advantage of .NET, to seperate presentation from logic.... if we are writing inline it will be more like ASP again...
  25. pulpfiction

    User Login

    You will first check the username/password. Then if the authentication is done, the maintain a session and check the session in every restricted page.... session stays till the browser is closed or timed out. if the user is not logged in then redirect to login page.
  • Create New...