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 <*> 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/
