I knew it was something simple I was not doing. It was late at night and was tired :) Thanks.
Have a nice day. ----- Original Message ----- From: "Ben Miller" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Monday, January 03, 2005 8:16 AM Subject: Re: [AspNetAnyQuestionIsOk] aspclassic to ASP.NET ..................................... > > You need to put ' (single quotes) around the data. > > SELECT * FROM tblBTC WHERE PlayingName LIKE '" & strPlayingName & "'" > > the above looks like (singlequote)(doublequote) & strPlayingName & > (doublequote)(singlequote)(doublequote) > > The delimiter when using strings is the single quote. > > Ben Miller > > ----- Original Message ----- > From: [EMAIL PROTECTED] > To: [email protected] > Sent: Sunday, January 02, 2005 9:47 PM > Subject: Re: [AspNetAnyQuestionIsOk] aspclassic to ASP.NET > ..................................... > > > So far I did manage to get the repeater to work and made the member page > listing :) > http://webslave/btcNET/ViewBTCMemberIndex.aspx and thanks to al that have > help so far thank you. > > > I am not making my Sql String correctly I guess as the code below results > in > an error also listed after the code. What I am attempting to do is just > get > the record with the member that was clicked from the preceding page. Then > I > will display it on the page. > > > <CODE> > > > '---------- Get Playingname from Querystring ------ > > Dim strPlayingName As String > > strPlayingName = Request.QueryString("PlayingName") > > > > Dim strSQLstring As String > > strSQLstring = "SELECT * FROM tblBTC WHERE PlayingName LIKE " & > strPlayingName > > '-------------------------------- > > > > 'Create a DataAdapter ------------------------------------ > > Dim objDataAdapter As OleDbDataAdapter > > 'objDataAdapter = New OleDbDataAdapter("SELECT * FROM tblBTC", objConn) > > objDataAdapter = New OleDbDataAdapter(strSQLstring, objConn) > > > </CODE> > > > > > Syntax error (missing operator) in query expression 'PlayingName LIKE > Hudson[BTC]'. > Description: An unhandled exception occurred during the execution of the > current web request. Please review the stack trace for more information > about the error and where it originated in the code. > > Exception Details: System.Data.OleDb.OleDbException: Syntax error (missing > operator) in query expression 'PlayingName LIKE Hudson[BTC]'. > > Source Error: > > An unhandled exception was generated during the execution of the > current web request. Information regarding the origin and location of the > exception can be identified using the exception stack trace below. > > Stack Trace: > > [OleDbException (0x80040e14): Syntax error (missing operator) in query > expression 'PlayingName LIKE Hudson[BTC]'.] > > > > > > Mike Belcher > Independant Computer Consultant > Email: [EMAIL PROTECTED] > > > > Have a nice day. > ----- Original Message ----- > From: "Ben Miller" <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Wednesday, December 29, 2004 12:05 PM > Subject: Re: [AspNetAnyQuestionIsOk] aspclassic to ASP.NET > > >> >> I have attached a Repeater definition that should work. >> >> This should generate the correct looking layout that you have on your >> site >> currently. All you need is a DataTable with the data using the same >> fieldnames that you had in your objRS("fieldname") stuff. >> >> Ben Miller >> >> ----- Original Message ----- >> From: Ben Miller >> To: [email protected] >> Sent: Wednesday, December 29, 2004 9:36 AM >> Subject: Re: [AspNetAnyQuestionIsOk] aspclassic to ASP.NET >> >> >> Looking at the page referenced below, you have a great example of using a >> DataList or a Repeater control. DataList will generate beginning table >> and >> ending table tags and you can form the layout inside like you have. If >> you >> use a Repeater then you have full control of the HTML and table tags to >> get >> what you want. >> >> This is not that bad, as you would have a databinding statement wherever >> you >> have the objRS("fieldname") and the rest would remain the same. >> >> HTH. I will reply with a template if I get time today. >> >> Ben Miller >> >> ----- Original Message ----- >> From: [EMAIL PROTECTED] >> To: [email protected] >> Sent: Tuesday, December 28, 2004 9:49 PM >> Subject: [AspNetAnyQuestionIsOk] aspclassic to ASP.NET >> >> >> I am in the process of converting an aspclassic website I have over to >> asp.net before I do anything more with it. I would like it to do at least >> what it is able to do now. It has custom views I made with aspclassic and >> forms to edit etc.... I am having issues at the moment just making a >> simple >> connection to a .MDB file. I can go into server explorer and make the >> connection using visual studio .net no problem but its >> LONG....................... I also want to make data generate in the way >> it >> does not with asp classic. The site is www.belchingtoadclan.com and it is >> a >> little old but before adding more features to it I want to convert it >> over. >> Some things are confusing in how to get the same results in .net. Like a >> page to list the members of the gaming clan >> >> http://belchingtoadclan.gotdns.com/btc2/_Scripts/ViewBTCMemberIndex.asp >> >> >> that lists the members. How can I make the same custom type page >> generation in .net? If you click on a member there is another custom >> generated page. SO far in .net its datagrids etc but that isn't what I >> need. >> Here is the code from the page listed above its OLD. As far as included >> content goes I got that figured out. Its the building of the page the way >> it >> is done now and making that happen in .NET - This is the best list there >> is >> so I posted here. Thank you. >> >> >> <CODE> >> <%@ Language=VBScript %> >> <% Option Explicit %> >> <!--#include file="adovbs.inc"--> >> <!--#include file="DatabaseConnect.asp"--> >> >> <HTML><head> >> >> <style> >> <!-- >> .bodyfont { FONT-FAMILY: Tahoma, Arial, Verdana, Helvetica; FONT-SIZE: >> 9pt; } >> .lrgheader { FONT-FAMILY: Tahoma, Arial, Verdana, Helvetica; FONT-SIZE: >> 9pt; FONT-WEIGHT: 700; } >> .header { FONT-FAMILY: Tahoma, Arial, Verdana, Helvetica; FONT-SIZE: >> 8pt; >> FONT-WEIGHT: 700; } >> .content { FONT-FAMILY: Tahoma, Arial, Verdana, Helvetica; FONT-SIZE: >> 7pt; >> FONT-WEIGHT: 400; } >> --> >> </style> >> >> <STYLE>BODY { >> SCROLLBAR-FACE-COLOR: #000000; SCROLLBAR-HIGHLIGHT-COLOR: #000000; >> SCROLLBAR-SHADOW-COLOR: #000000; SCROLLBAR-ARROW-COLOR: #000000; >> SCROLLBAR-TRACK-COLOR: #000000; SCROLLBAR-DARKSHADOW-COLOR: #000000 >> } >> </style> >> >> <style fprolloverstyle>A:hover {color: #00FF00; font-weight: bold} >> </style> >> >> >> >> >> >> </head> >> <body bgcolor="#000000" text="#C0C0C0" link="#FFFFFF" vlink="#FFFFFF" >> alink="#FFFFFF" background="../_Images/right.gif" bgproperties="fixed"> >> <div align="center"> >> <table border="0" cellpadding="0" cellspacing="0" width="572"> >> <tr> >> <td> >> <!--webbot bot="Include" U-Include="../MenuSystem/Menu.htm" >> TAG="BODY" --></td> >> </tr> >> <tr> >> <td> >> <br> >> <div align="center"> >> <div align="center"> >> <table border="1" cellpadding="3" cellspacing="0" width="383" >> id="table3" bordercolorlight="#666666" bordercolordark="#333333"> >> <tr> >> <td nowrap background="../_Images/Development/metal3Dark.gif"> >> <p align="center"><font face="Verdana" size="5" color="#808000"> >> <b>B</b>elching >> <b>T</b>oad <b>C</b>lan Members</font></td> >> </tr> >> </table> >> </div> >> </div> >> </td> >> </tr> >> </table> >> </div> >> <% >> 'AUTHOR MIKE BELCHER >> 'THIS WILL LIST THE MEMBERS >> %> >> >> <% >> 'create a SQL statement to list the Events by ProgramStart >> >> >> >> Dim strSQL >> strSQL = "SELECT * FROM tblBTC" & " ORDER BY DateJoined" >> >> Dim objRS >> Set objRS = Server.CreateObject("ADODB.Recordset") >> objRS.Open strSQL, objConn >> >> Response.Write "<center><table border=""0"" width=""575"" >> cellpadding=""0"" cellspacing=""0"" height=""303"">" >> Response.Write "<tr>" >> Response.Write "<td>" >> >> Dim strLink, strPlayingName, strLocation, strCounter, strEmail >> Response.Write "<BR><BR><center>" >> >> strCounter = 0 >> Do While Not objRS.EOF >> strCounter = strCounter + 1 >> strPlayingName = objRS("PlayingName") >> strEmail = objRS("Email") >> strPlayingName = Server.URLEncode(strPlayingName) >> >> strPlayingName=Replace(strPlayingName, "~", "%7E")' tilde >> strPlayingName=Replace(strPlayingName, "`", "%60")' ` >> strPlayingName=Replace(strPlayingName, "!", "%21")' exclamation >> strPlayingName=Replace(strPlayingName, "@", "%40")' @ >> strPlayingName=Replace(strPlayingName, "#", "%23")' pound >> strPlayingName=Replace(strPlayingName, "$", "%24")' dollar sign >> 'strPlayingName=Replace(strPlayingName, "%", "%2525")' percent sign >> strPlayingName=Replace(strPlayingName, "^", "%5E")' exponent >> strPlayingName=Replace(strPlayingName, "&", "%26")' and >> strPlayingName=Replace(strPlayingName, "*", "%2A")' and >> strPlayingName=Replace(strPlayingName, "(", "%28")' ( >> strPlayingName=Replace(strPlayingName, ")", "%29")' ) >> strPlayingName=Replace(strPlayingName, ",", "%2C")' comma >> strPlayingName=Replace(strPlayingName, "'", "%27")' apostrophe >> strPlayingName=Replace(strPlayingName, "-", "%2D")' dash >> strPlayingName=Replace(strPlayingName, "_", "%5F")' underscore >> strPlayingName=Replace(strPlayingName, "+", "%20")' plus >> strPlayingName=Replace(strPlayingName, "=", "%3D")' equal >> strPlayingName=Replace(strPlayingName, "{", "%7B")' left bracket >> strPlayingName=Replace(strPlayingName, "}", "%7D")' right bracket >> strPlayingName=Replace(strPlayingName, "[", "%5B")' [ >> strPlayingName=Replace(strPlayingName, "]", "%5D")' [ >> strPlayingName=Replace(strPlayingName, "|", "%7C")' | >> strPlayingName=Replace(strPlayingName, "\", "%5C")' \ >> strPlayingName=Replace(strPlayingName, "/", "%2F")' / >> strPlayingName=Replace(strPlayingName, ":", "%3A")' : >> strPlayingName=Replace(strPlayingName, ";", "%3B")' ; >> 'strPlayingName=Replace(strPlayingName, """, "%22")' qoute >> strPlayingName=Replace(strPlayingName, "<", "%3C")' < >> strPlayingName=Replace(strPlayingName, ">", "%3E")' > >> strPlayingName=Replace(strPlayingName, ".", "%2E")' . >> >> >> Response.Write "<table border=""0"" width=""780"" cellpadding=""3"" >> cellspacing=""3"" id=""table2""><tr>" >> Response.Write "<td width=""50"" >> background=""../_Images/Development/bg2.gif""><br></td><td>" >> Response.Write "<div align=""center"">" >> Response.Write "<table border=""2"" cellpadding=""3"" cellspacing=""0"" >> width=""100%"" align=""left"" id=""table3"" >> background=""../_Images/Development/metal3Dark.gif"" >> bordercolorlight=""#666666"" bordercolordark=""#333333"" >> bgcolor=""#292929"">" >> Response.Write "<tr>" >> Response.Write "<td><font face=""Verdana""><B><BIG><BIG>" >> Response.Write "<font size=""5"" color=""#C0C0C0"">" >> Response.Write "<a href='../_scripts/ViewBTCMemberfromindex.asp?" & >> objRS("PlayingName") & "'>" & objRS("PlayingName") & >> "<a/></font></BIG></BIG></B>" >> Response.Write "</font><font color=""#008000""><font face=""Verdana"" >> size=""2""><b><br>" >> Response.Write "JOINED: </b><font color=""#00ff00"">" & >> objRS("DateJoined") & "<br></font></font>" >> Response.Write "<font face=""Verdana"" size=""2"" >> color=""#008000""><b>NAME:</b><font color=""#00ff00"">" & objRS("Name") & >> "</font></font>" >> Response.Write "<font color=""#008000"" face=""Verdana"" >> size=""4""><br>" >> Response.Write "</font><font face=""Verdana"" size=""2"" >> color=""#008000""><b>AGE:</b> <font color=""#00ff00"">" & objRS("Age") & >> "</font></font>" >> Response.Write "<font face=""Verdana"" size=""4""><br></font></font>" >> Response.Write "<font face=""Verdana"" color=""#008000"" >> size=""2""><b>LOCATION:</b> <font color=""#00ff00"">" & objRS("Location") >> & >> "</font></font>" >> Response.Write "<SMALL><font face=""Verdana"" >> color=""#0080FF""><br></FONT></SMALL>" >> Response.Write "<font face=""Verdana"" color=""#008000"" >> size=""2""><b>EMAIL:</b> <font color=""#00ff00""><a href='mailto:"; & >> strEmail & "?Subject=Mail from BelchingToadClan Members Page'>" & >> objRS("Email") & "</a></font></font>" >> Response.Write "<font face=""Verdana"" size=""4"" >> color=""#008000""><br></font>" >> Response.Write "<font face=""Verdana"" color=""#008000"" >> size=""2""><b>AIM:</b> <font color=""#00ff00""><A >> href=""aim:goim?screenname=" & objRS("Aim") & """>" & objRS("Aim") & >> "</A></font></font><br>" >> Response.Write "<font face=""Verdana"" size=""2"" >> color=""#008000""><b>ICQ:</b><font color=""#00ff00"">" & objRS("Icq") & >> "<br></font>" >> Response.Write "<b>CONNECTION:</b></font><font face=""Verdana"" >> size=""2"" >> color=""#00FF00"">" & objRS("Connect") & "</font>" >> Response.Write "</td>" >> Response.Write "</tr>" >> Response.Write "</table>" >> Response.Write "</div>" >> Response.Write " </td>" >> Response.Write "<td width=""268"" >> background=""../_Images/Development/bg2.gif"">" >> Response.Write " </td></tr><tr>" >> Response.Write "<td width=""50"">" >> Response.Write "<br>" >> Response.Write " </td><td>" >> Response.Write " </td>" >> Response.Write "<td width=""268"">" >> Response.Write " </td></tr></table>" >> >> >> >> 'Response.Write "<B><img src=""../_Images/sarge.gif"" width=""21"" >> height=""32"" border=""0""><BIG><BIG><a class=""roll"" >> href='../_scripts/ViewBTCMemberfromindex.asp?" & objRS("PlayingName") & >> "'>" >> & objRS("PlayingName") & "</a></B></BIG></BIG></FONT><BR> " >> 'Response.Write "<SMALL><font face=""Verdana"" color=""#0080FF"">" & >> objRS("Location") & "</FONT></SMALL><BR>" >> 'Response.Write "<SMALL><a href='mailto:"; & strEmail & "?Subject=Mail >> from >> BelchingToadClan Members Page'>" & objRS("Email") & "</a></B></SMALL>" >> 'Response.Write "<BR><BR><BR>" >> objRS.MoveNext >> Loop >> 'Response.Write "<BIG>THERE ARE CURRENTLY <B>[" & strCounter & "]</B> >> BTC >> MEMBERS</BIG><br>" >> 'Response.Write "</td>" >> 'Response.Write "</tr><tr><td width=""575""><!--webbot bot=""Include"" >> U-Include=""../Footer.htm"" TAG=""BODY"" startspan --></td></table>" >> >> >> %> >> >> <p> </p> >> >> <% >> objRS.Close >> Set objRS = Nothing >> objConn.Close >> Set objConn = Nothing >> %> >> </FONT> >> <!--webbot bot="Include" U-Include="../MenuSystem/Footer.htm" >> TAG="BODY" --> >> </BODY> >> </HTML> >> </CODE> >> >> >> >> Mike Belcher >> Independant Computer Consultant >> >> Email: [EMAIL PROTECTED] >> >> >> [Non-text portions of this message have been removed] >> >> >> Yahoo! Groups Sponsor >> ADVERTISEMENT >> >> >> >> >> >> ------------------------------------------------------------------------------ >> Yahoo! Groups Links >> >> a.. To visit your group on the web, go to: >> http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ >> >> b.. To unsubscribe from this group, send an email to: >> [EMAIL PROTECTED] >> >> c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of >> Service. >> >> >> >> [Non-text portions of this message have been removed] >> >> >> Yahoo! Groups Sponsor >> ADVERTISEMENT >> >> >> >> >> >> >> Yahoo! Groups Links >> >> To visit your group on the web, go to: >> http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ >> >> To unsubscribe from this group, send an email to: >> [EMAIL PROTECTED] >> >> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. >> >> ---------- >> >> <asp:Repeater id="ClanMembersList" runat="server"> >> <HeaderTemplate> >> <table border="0" width="780" cellpadding="3" cellspacing="3"> >> <tr> >> </HeaderTemplate> >> <ItemTemplate> >> <td width="50" background="../_Images/Development/bg2.gif"><br></td> >> <td> >> <div align="center"> >> <table border="2" cellpadding="3" cellspacing="0" width="100%" >> align="left" id="table3" >> background="../_Images/Development/metal3Dark.gif" >> bordercolorlight="#666666" bordercolordark="#333333" bgcolor="#292929"> >> <tr> >> <td><font face="Verdana"><B><BIG><BIG> >> <font size="5" color="#C0C0C0"> >> <a href='../_scripts/ViewBTCMemberfromindex.asp?<%# >> DataBinder.Eval(Container.DataItem, "PlayingName") %>'><%# >> DataBinder.Eval(Container.DataItem, "PlayingName") >> %><a/></font></BIG></BIG></B> >> </font><font color="#008000"><font face="Verdana" size="2"><b><br> >> JOINED: </b><font color="#00ff00"><%# DataBinder.Eval(Container.DataItem, >> "DateJoined") %><br></font></font> >> <font face="Verdana" size="2" color="#008000"><b>NAME:</b><font >> color="#00ff00"><%# DataBinder.Eval(Container.DataItem, "Name") >> %></font></font> >> <font color="#008000" face="Verdana" size="4"><br> >> </font><font face="Verdana" size="2" color="#008000"><b>AGE:</b> <font >> color="#00ff00"><%# DataBinder.Eval(Container.DataItem, "Age") >> %></font></font> >> <font face="Verdana" size="4"><br></font></font> >> <font face="Verdana" color="#008000" size="2"><b>LOCATION:</b> <font >> color="#00ff00"><%# DataBinder.Eval(Container.DataItem, "Location") >> %></font></font> >> <SMALL><font face="Verdana" color="#0080FF"><br></FONT></SMALL> >> <font face="Verdana" color="#008000" size="2"><b>EMAIL:</b> <font >> color="#00ff00"><a href='mailto:<%# DataBinder.Eval(Container.DataItem, >> "Email") %>?Subject=Mail from BelchingToadClan Members Page'><%# >> DataBinder.Eval(Container.DataItem, "Email") %></a></font></font> >> <font face="Verdana" size="4" color="#008000"><br></font> >> <font face="Verdana" color="#008000" size="2"><b>AIM:</b> <font >> color="#00ff00"><A href='aim:goim?screenname=<%# >> DataBinder.Eval(Container.DataItem, "Aim") %>'><%# >> DataBinder.Eval(Container.DataItem, "Aim") %></A></font></font><br> >> <font face="Verdana" size="2" color="#008000"><b>ICQ:</b><font >> color="#00ff00"><%# DataBinder.Eval(Container.DataItem, "Icq") >> %><br></font> >> <b>CONNECTION:</b></font><font face="Verdana" size="2" >> color="#00FF00"><%# >> DataBinder.Eval(Container.DataItem, "Connect") %></font> >> </td> >> </tr> >> </table> >> </div> >> </td> >> <td width="268" background="../_Images/Development/bg2.gif"> </td> >> </tr> >> <tr> >> <td width="50"> >> <br> >> </td> >> <td> >> </td> >> <td width="268"> >> </td> >> </ItemTemplate> >> <FooterTemplate> >> </tr> >> </table> >> </FooterTemplate> >> </asp:Repeater> >> >> >> >> [Non-text portions of this message have been removed] >> >> >> >> >> >> Yahoo! Groups Links >> >> >> >> >> >> >> >> > > > > > > Yahoo! Groups Links > > To visit your group on the web, go to: > http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ > > To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. > > > > > Yahoo! Groups Links > > > > > > > > Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
