HP3000-L Archives

May 2003, Week 3

HP3000-L@RAVEN.UTC.EDU
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
OT: CGI and MS Access question
From:
Gary Nolan <[log in to unmask]>
Reply To:
Gary Nolan <[log in to unmask]>
Date:
Tue, 20 May 2003 19:47:33 -0300
Content-Type:
text/plain
Parts/Attachments:
text/plain (21 lines) 
Hi Folks,

A little brain teaser:

Using CGI to retrieve records from an Access data base the following works:

select name from customer where custid like '1001'

But when we try:

select name from customer where custid like '1*'

It does not work. I think that CGI is looking at the * and trying to do something with it. Any way around this? Is there a special character I should put in front of the * so it will not get acted on?

I am not very verse in CGI yet, so I would appreciate any ideas.

Gary Nolan

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

ATOM RSS1 RSS2