Hello members,
I'm new to mysql and need to conect to from ASP pages.
I have written the following code in ASP script
<!- #include file="C:\PROGRAM FILES\COMMON FILES\SYSTEM\ADO\adovbs.inc" ->
<%
dim email,objrs,strsql,strconn
email=Request.Form ("email")
strconn = "DSN=ebyte"
strsql="select * from log where email=('" & email & "');"
set objrs=server.CreateObject ("adodb.recordset")
With objrs
.ActiveConnection = strconn
.Source = strsql
.Open
End With
Response.Write objrs("email")
Set objrs = Nothing
%>
i get the following error msg on the browser
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified
i have checked the dsn and the adminstrator say its fine.
Background info
mysql installed on linux server and site hosted on iis server on windows
2000
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, November 04, 2002 9:57 AM
Subject: getting around a subselect
>
> As a novice in (My)sql I encounter this problem:
>
> I would like to select from a table first the 39 records with the highest
> variable1 and order them on variable2.
> So I need something like a subselect and I can't figure out a way around
it.
>
> Ideally something like:
> select * from table1 order by var2 in (select * from table1 order by var1
limit
> 0,39);
>
> Best regards
> Hein
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
