ASP + MySQL help

craymel · 11-15-2005, 07:04 AM

hello , i'm quite new to ASP and MySQL . So i kinda need help T.T .

I wanna make a site that show random words . I have a database , so i put this in the script .

<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("datafile.mdb"))

set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT TOP 1 morning, evening, night, midnight FROM anotherday ORDER BY RAND(ID) LIMIT 1"
rs.Open sql, conn
%>

is there anything wrong ? because it says smthg like :

Syntax error (missing operator) in query expression 'RAND(ID) LIMIT 1'

thank you and sorry for my bad english .

**Grove** · 11-16-2005, 10:55 PM

I think you'll find not too many of us are great at ASP.

Sorry, I'll see if Google can help

**Grove** · 11-19-2005, 11:35 PM

Looks like Google also bailed out on me. Sorry about that.

11-15-2005, 07:04 AM	#1 (permalink)
craymel Registered User Join Date: Nov 2005 Posts: 1 OS: XP	ASP + MySQL help hello , i'm quite new to ASP and MySQL . So i kinda need help T.T . I wanna make a site that show random words . I have a database , so i put this in the script . <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("datafile.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT TOP 1 morning, evening, night, midnight FROM anotherday ORDER BY RAND(ID) LIMIT 1" rs.Open sql, conn %> is there anything wrong ? because it says smthg like : Syntax error (missing operator) in query expression 'RAND(ID) LIMIT 1' thank you and sorry for my bad english .

11-16-2005, 10:55 PM	#2 (permalink)
Grove Professor/Moderator, TSF Design School Join Date: Jun 2005 Location: Australia Posts: 2,383 OS: Windows Vista SP2 32bit	I think you'll find not too many of us are great at ASP. Sorry, I'll see if Google can help __________________ ========================================== Get Help: TSF Security Forum \| HijackThis \| MB's 5 Step Process Get Clean: AdAware SE \| Spybot S&D \| CWShredder \| Ewido \| CleanUp! Get Protected: SpywareBlaster \| SpywareGuard \| Windows Updates \| IE-SpyAd If TSF has helped you, please consider making a donation to help keep the board running.

11-19-2005, 11:35 PM	#3 (permalink)
Grove Professor/Moderator, TSF Design School Join Date: Jun 2005 Location: Australia Posts: 2,383 OS: Windows Vista SP2 32bit	Looks like Google also bailed out on me. Sorry about that. __________________ ========================================== Get Help: TSF Security Forum \| HijackThis \| MB's 5 Step Process Get Clean: AdAware SE \| Spybot S&D \| CWShredder \| Ewido \| CleanUp! Get Protected: SpywareBlaster \| SpywareGuard \| Windows Updates \| IE-SpyAd If TSF has helped you, please consider making a donation to help keep the board running.