Re: query problem

On Mon, Oct 21, 2002 at 04:05:06PM -0500, Jennifer Swofford wrote: > The client was doing a whole batch of updates... and it seems that the > query works for some items and not for others. For instance, I have a > category called "Auto and Garage", and of the 7 items in that category, > only 1 is updatable. In the "For the Birds" category, 12 of the 20 > items are updatable. It is always the same items that fail. Make sure these fields don't have any special characters in them, either at the database level, shell level, or html level. Proper quoting/encoding is essential for things like this to work. Also, make sure you are not passing GET or POST data with imbeded spaces as part of the query, as the URL will break. See urlencode in the php manual. Tim -- Tim Sailer <sailer@bnl.gov> Application Services Information Technology Division Brookhaven National Laboratory (631) 344-3001