OOPS!
Trying to do too many things at once.
OnItems was your recordset name, so
response.write(OnItems.fields.item("Description").value)
Sorry.
J.R.
-----Original Message-----
From: J.R. Pitts [mailto:listuser@;wjponline.com]
Sent: Friday, November 08, 2002 10:32 PM
To: [EMAIL PROTECTED]
Subject: [wdvltalk] RE: ACCESS & ASP problem
If I'm understanding your question properly, you need a where clause.
SELECT Description FROM Items WHERE ItemNumber=2
response.write(Connect.fields.Item("Description").value)
If 2 is stored as number; '2' if as text.
note that
value is the default property of item
item is the default collection of field
and fields is the default collection of a recordset, so
Connect("Description")
will work as a shortcut. But for clarity, and performance (I think) a lot of
people will write it out. The code is probably more portable that way, also.
HTH, Let me know if this wasn't what you were asking.
J.R.
-----Original Message-----
From: Ingentus [mailto:ingentus@;eircom.net]
Sent: Friday, November 08, 2002 9:56 PM
To: [EMAIL PROTECTED]
Subject: [wdvltalk] ACCESS & ASP problem
http://www.ingentus.com/access.htm
Hi everyone
I'm having a serious (seriously Stuck!) problem with an Access DB & ASP -
in this case I thought it would be easier explained with a screen shot & a
URL.
If anyone has the time to have a look I'd really appreciate it as always.
TIA
jac.
____ � The WDVL Discussion List from WDVL.COM � ____
To Join wdvltalk, Send An Email To: mailto:wdvltalk-join@;lists.wdvl.com
Send Your Posts To: [EMAIL PROTECTED]
To change subscription settings to the wdvltalk digest version:
http://wdvl.internet.com/WDVL/Forum/#sub
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [EMAIL PROTECTED]
To unsubscribe send a blank email to %%email.unsub%%
____ � The WDVL Discussion List from WDVL.COM � ____
To Join wdvltalk, Send An Email To: mailto:wdvltalk-join@;lists.wdvl.com
Send Your Posts To: [EMAIL PROTECTED]
To change subscription settings to the wdvltalk digest version:
http://wdvl.internet.com/WDVL/Forum/#sub
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [EMAIL PROTECTED]
To unsubscribe send a blank email to %%email.unsub%%
____ � The WDVL Discussion List from WDVL.COM � ____
To Join wdvltalk, Send An Email To: mailto:wdvltalk-join@;lists.wdvl.com
Send Your Posts To: [EMAIL PROTECTED]
To change subscription settings to the wdvltalk digest version:
http://wdvl.internet.com/WDVL/Forum/#sub
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
