Re: query - primary key

2002-05-20 Thread Amer Neely
Hi, Firstly, how do i correct that error of BAD text coz i actually have a text file which has a HISTORY dump from IE. Secondly what about the Duplicate Entry stuff, its comming for all the URLs why?? Regards Sameer It's been my experience with loading data from text

query - primary key

2002-05-19 Thread Sameer Maggon
Hi, I have a table with four colums id date time addr - varchar (used my sql C API) I want that when i add an entry, the PRIMARY KEY IS ALL OF THEM means that no entry should repeat. I used ALTER TABLE sss ADD PRIMARY KEY (all four field) but not when i add my things,

Re: query - primary key

2002-05-19 Thread Dan Nelson
In the last episode (May 20), Sameer Maggon said: Hi, I have a table with four colums id date time addr - varchar (used my sql C API) I want that when i add an entry, the PRIMARY KEY IS ALL OF THEM means that no entry should repeat. I used ALTER TABLE sss ADD

Re: query - primary key

2002-05-19 Thread Sameer Maggon
Hi, Here are the errors i am getting You have an error in your SQL syntax near 'http://www.indianrail.gov.in/frame.html') file://C:\\IIK\\for_you.html ')' at line 1 You have an error in your SQL syntax near 'http://www.cultureholidays.com/')file://C:\\IIK\\Tour_del.html ')' at line 1 You

Re: query - primary key

2002-05-19 Thread Dan Nelson
In the last episode (May 20), Sameer Maggon said: Hi, Here are the errors i am getting You have an error in your SQL syntax near 'http://www.indianrail.gov.in/frame.html') file://C:\\IIK\\for_you.html ')' at line 1 I'd take a look at this error first; you seem to be passing bad

Re: query - primary key

2002-05-19 Thread Sameer Maggon
Hi, Firstly, how do i correct that error of BAD text coz i actually have a text file which has a HISTORY dump from IE. Secondly what about the Duplicate Entry stuff, its comming for all the URLs why?? Regards Sameer -- you wrote: I'd take a look at this error first; you seem