Hi Alex,
> sql="SELECT * FROM adquestbank WHERE qid IN (" & lottery & ")"
> RESPONSE.WRITE sql
> ...
> comes up with:
> 4,5,7,8,10,11SELECT * FROM adquestbank WHERE qid IN ()
> ...
> But why are the numbers coming up at the begining of the
> line and not in the brackets as required for the request?
Because you're not returning the value with the Lotery Function,
you're "response.write"ing it:
'// ========================================================
FUNCTION LOTTERY
...
Response.Write(initialarray(i))
...
Response.Write(",")
...
END FUNCTION
'// ========================================================
Instead, build them into a string like this:
sLottery = sLottery & initialarray(i)
and
sLottery = sLottery & ","
Then return it using:
LOTTERY = sLottery
Regards,
Shawn K. Hall
http://ReliableAnswers.com/
'// ========================================================
Join my war on technology...send me a FAX.
-- Mark Russell
------------------------ 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/
