Creating the correct SQL statement

2001-06-21 Thread Craig Atkins
n someone possibly give me any ideas?? (if I haven't confused you already!) ;-)   Thanks in Advance   Craig Atkins Web Developer Sire Technology Ltd. +44 (0) 1344 758700 http://www.sire.co.uk   * This e-mail and its contents are c

Problem with MySQL & ASP

2001-03-19 Thread Craig Atkins
Hi I am running the latest versions of MySQL and MyODBC on my windows 200 webserver. I am trying to connect to my database and pull out some simple data with asp. The code i am using is: <% dim db dim strConn dim rs dim QueryStr QueryStr = "SELECT * FROM imagedata" strConn = "mediaSafe" Set

How To Generate The SELECT statement I need

2001-01-18 Thread Craig Atkins
o', which could mean "John" or "LittleJohn"   How can I do this in MySQL? How can I make it case sensitive or insensitive.   Thank You For Your Help,   Craig Atkins * This e-mail and its contents are