RE: more about using sets

2002-12-17 Thread Anderson, Alan R
> From: David T-G [mailto:[EMAIL PROTECTED]] > ...I still have to figure > out how to make sure that our credit card types and skill levels don't > get corrupted (MC, MasterCard, mastercard, ...), but I guess that gets > enforced in the software interface, right? Isn't the card type a piece of der

RE: ADO Bulk Inserts

2002-12-11 Thread Anderson, Alan R
> From: Michael She [mailto:[EMAIL PROTECTED]] > ...So are you saying that the Windows ODBC MySQL driver > doesn't support multiple statements? So far as I know, *no* drivers support multiple statements. However, that's not what you want for "bulk inserts". What you want is multiple value sets

RE: Desc question

2002-12-09 Thread Anderson, Alan R
> From: Alex Behrens [mailto:[EMAIL PROTECTED]] > ...How can I make it so only one form > selection adds a DESC tag to the query, is this possible? > > I'm using this code: > > $fetch = mysql_query("SELECT * FROM players ORDER BY $var"); > > > Name > Position > Number > Grade > > I want only t

RE: Can someone explain this?

2002-12-06 Thread Anderson, Alan R
> mysql> select sum(trial_signups) from campaign_t where > datestamp='20021204'\g > ++ > | sum(trial_signups) | > ++ > |100 | > ++ > > > mysql> SELECT site_id, sum(raws) As RawHits, sum(uniques) As > UniqueHits, > sum(t

RE: load data infile syntax

2002-11-07 Thread Anderson, Alan R
>If the data contains "\", then database will automatically takes "\" >away and shift 1 byte left. >My data will mass up. That is why I still need "\" Does your data actually include backslash characters? If you want to import them as they are, you definitely don't want to ESCAPE BY them. Esca

RE: update question

2002-11-01 Thread Anderson, Alan R
> -Original Message- > From: Jörgen Winqvist [mailto:jorgen@;winqvist.net] > > I need to let the values in two columns change place with each other. > I've tried to "update xxx set a=b, b=a" but that doesn't work > (b=a uses > the "new" a). Here's a cute trick for swapping two numbers w

RE: Need a little query help

2002-10-29 Thread Anderson, Alan R
> -Original Message- > From: Chris Mason [mailto:masonc@;masonc.com] > [...] > The problem is, it is easy to test for one amenity, but I need to test > that the hotel has all of the amenities. The query above > returns all the > hotels that have ANY of the amenities, I need the hotels hav