Slow response (just got back from holiday) but might still be relevant...
steve miller wrote:
The problem I am having is when I try to search for a user with a string
that has a ' or a in it, because the sql throws an error.
The id inserted into the query, so I end up with something like:
I am working with an existing database table that holds user
information identified by strange id strings. The id strings are
created by another application, so I can not change them, but I need
to be able to query the table using them as reference. Each ID is a 3
character string like:
Hi all...
I've not been here for AGES... but I hope many of you trusted clever
people are still out there... I need help! ;-p
I'm building a shop for a client.
I've got 3 tables I'm trying to talk to.
products
stock
categories
- Each product can be flagged with any numebr of cateogories using
I'm building a shop for a client.
this would be a good time to change the table design;o)
never put a comma-delimited string of ids into a single field
you need another table, ProductCategories, to contain two columns, productid
and categoryid
the reason? because sql like this...
Quoting r937 [EMAIL PROTECTED]:
I'm building a shop for a client.
this would be a good time to change the table design;o)
never put a comma-delimited string of ids into a single field
you need another table, ProductCategories, to contain two columns,
productid and categoryid
the