[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