I have the SQL statement:
sql = "SELECT * FROM quest WHERE questID = '" & questID & "' ORDER BY
questnumber ('3,5,9')"
In the database, there are several sets of questions (hence the questID
field), but then I want to just to be able to pick out a selected number (in
this case 3, 5 and 9)
The statement and page works with:
sql = "SELECT * FROM quest WHERE questID = '" & questID & "' ORDER BY
questnumber ASC"
What do I need to do to make it work with a specific set of question
numbers?
Many thanks
NOTE: The information contained in this email is intended for the named
recipients only, it may be privileged and confidential. If you are not the
intended recipient, you must not copy distribute or take any action in
reliance upon it. No warranties or assurances are made in relation to the
safety and content of this email and any attachments. No liability is
accepted for any consequences arising from it.
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
$9.95 domain names from Yahoo!. Register anything.
http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/17folB/TM
--------------------------------------------------------------------~->
---------------------------------------------------------------------
Home : http://groups.yahoo.com/group/active-server-pages
---------------------------------------------------------------------
Post : [EMAIL PROTECTED]
Subscribe : [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
---------------------------------------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/active-server-pages/
<*> 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/
