[AccessD] OT: ASP & ADO

Thanks to everyone who answered. Unfortunately I got diverted onto another
job and haven't had a chance to try any of your suggestions. Hopefully
tomorrow...!

Roz

-----Original Message-----
From: Randall Anthony [mailto:ranthony at wrsystems.com] 
Sent: 18 February 2003 14:45
To: 'accessd at databaseadvisors.com'
Subject: RE: [AccessD] OT: ASP & ADO


I think your code should look something like this:

<%
  sql = "select * from  tbl_user where username = '" & session("userid") &
"';"

  set rst = dbcon.execute(sql)
  
  if rst.eof then
%>

The <> symbols should work when contained within the <% %> which identifies
this as vb script.  HTH.

-----Original Message-----
From: Bob Gajewski [mailto:bob at renaissancesiding.com]
Sent: Tuesday, February 18, 2003 9:36 AM
To: 'accessd at databaseadvisors.com'
Subject: RE: [AccessD] OT: ASP & ADO


Roz

I won't even begin to suggest that I have the slightest clue about ASP, but 
I do know that the greater-than and less-than symbols are identified by 
> and < in HTML.

Maybe that will help ...

Regards,
Bob Gajewski


On Tuesday, February 18, 2003 08:45 AM, Roz Clarke 
[SMTP:roz.clarke at donnslaw.co.uk] wrote:
> Hi all
>
> I need to port some code from an Access form into an ASP page. I know
stuff
> all about ASP so I don't even know where to begin, but the most 
> immediate problem I'm having is that my WHERE statement in my ADO 
> query contains <
and
> > symbols, which of course won't work in the context of a web page. 
> > How
can
> I get around this / can anyone recommend some reading material on ADO
syntax
> in ASP?
>
> Thanks
>
> Roz
>  << File: ATT00013.htm >>

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com