|
From: Teijo A. <tab...@gm...> - 2009-04-04 15:56:22
|
hi I can run your example fine too. Here's two lines from my dump with create table script: CREATE TABLE "albums" ( id int PRIMARY KEY NOT NULL, band int, description text, title varchar(255), link text, released varchar(255), genres text, tracks text, credits text, label varchar(255), num_of_tracks smallint, cds smallint, status smallint NOT NULL, link_small text ) INSERT INTO albums VALUES (2,11825,NULL,'Anderson Bruford Wakeman Howe','<iframe src=\" http://rcm.amazon.com/e/cm?t=0c-20&o=1&p=8&l=as1&asins=B000002VGG&fc1=000000&=1&lc1=0000ff&bc1=000000&lt1=_blank&IS2=1&bg1=ffffff&f=ifr\" style=\"width:120px;height:240px;\" scrolling=\"no\" marginwidth=\"0\" marginheight=\"0\" frameborder=\"0\"></iframe>','01/01/1989','Classic Rock','1. Themes (5:58)\r\n2. Fist of Fire (3:27)\r\n3. Brother of Mine (10:18)\r\n4. Birthright (6:02)\r\n5. The meeting (4:21)\r\n6. Quartet (9:22)\r\n7. Teakbois (7:39)\r\n8. Order of the Universe (9:02)\r\n9. Let\'s pretend (2:56)','John Anderson / vocals\r\nBill Bruford / drums\r\nRick Wakeman / keyboards\r\nSteve Howe / guitar\r\nTony Levin / bass, vocals and stick bass\r\nMilton McDonald / guitar (rhythm)','Bmg',9,1,1,NULL); INSERT INTO albums VALUES (3,581,NULL,'Californication','<iframe src=\" http://rcm.amazon.com/e/cm?t=0c-20&o=1&p=8&l=as1&asins=B00000J7JO&fc1=000000&=1&lc1=0000ff&bc1=000000&lt1=_blank&IS2=1&bg1=ffffff&f=ifr\" style=\"width:120px;height:240px;\" scrolling=\"no\" marginwidth=\"0\" marginheight=\"0\" frameborder=\"0\"></iframe>','June 8,1999','Rock/Pop','1. Around the World 3:58\r\n2. Parallel Universe 4:30\r\n3. Scar Tissue 3:37\r\n4. Otherside 4:15\r\n5. Get on Top 3:18\r\n6. Californication 5:21\r\n7. Easily 3:51\r\n8. Porcelain 2:43\r\n9. Emit Remmus 4:00\r\n10. I Like Dirt 2:37\r\n11. This Velvet Glove 3:45\r\n12. Savior 4:52\r\n13. Purple Stain 4:13\r\n14. Right on Time 1:52\r\n15. Road Trippin\' 3:25',null,'Warner Bros',15,1,1,NULL); If I run them separately, they go though fine, but when I select both it fails to: Error: ERROR: unterminated quoted string at or near "'<iframe src=\" http://rcm.amazon.com/e/cm?t=0c-20&o=1&p=8&l=as1&asins=B00000J7JO&fc1=000000&=1&lc1=0000ff&bc1=000000&l " SQLState: 42601 ErrorCode: 0 Error occured in: INSERT INTO albums VALUES (2,11825,NULL,'Anderson Bruford Wakeman Howe','<iframe src=\" http://rcm.amazon.com/e/cm?t=0c-20&o=1&p=8&l=as1&asins=B000002VGG&fc1=000000&=1&lc1=0000ff&bc1=000000&lt1=_blank&IS2=1&bg1=ffffff&f=ifr\" style=\"width:120px;height:240px;\" scrolling=\"no\" marginwidth=\"0\" marginheight=\"0\" frameborder=\"0\"></iframe>','01/01/1989','Classic Rock','1. Themes (5:58)\r\n2. Fist of Fire (3:27)\r\n3. Brother of Mine (10:18)\r\n4. Birthright (6:02)\r\n5. The meeting (4:21)\r\n6. Quartet (9:22)\r\n7. Teakbois (7:39)\r\n8. Order of the Universe (9:02)\r\n9. Let\'s pretend (2:56)','John Anderson / vocals\r\nBill Bruford / drums\r\nRick Wakeman / keyboards\r\nSteve Howe / guitar\r\nTony Levin / bass, vocals and stick bass\r\nMilton McDonald / guitar (rhythm)','Bmg',9,1,1,NULL); INSERT INTO albums VALUES (3,581,NULL,'Californication','<iframe src=\" http://rcm.amazon.com/e/cm?t=thetabworld0c-20&o=1&p=8&l=as1&asins=B00000J7JO&fc1=000000&=1&lc1=0000ff&bc1=000000&l I have about 500 of these and each time I select > 1 line it fails like this.It's as if it tries to end the statement to the semicolon, and then complains about the missing quote, since if I remove the semicolon near "118;" it then complains about the next semicolon at "116;". If I try to change the statement separator to a different char, Squirrel just hangs eating up all cpu for several minutes and does nothing. Running version 2.6.4, Postgres 8.3, JRE 1.6 Thanks for any help :) On Sat, Apr 4, 2009 at 5:57 PM, Robert Manning <rob...@gm...>wrote: > I wasn't able to reproduce it with this script (';' near the end of > the url - a;2 ) : > > create table testurl (myid integer, myurl varchar(255)) > > INSERT INTO testurl (MYID,MYURL) VALUES > (0,'http://foo.com:8080/bug.cgi?key=1&val=a;2'<http://foo.com:8080/bug.cgi?key=1&val=a;2%27> > ); > INSERT INTO testurl (MYID,MYURL) VALUES > (1,'http://foo.com:8080/bug.cgi?key=1&val=a;2'<http://foo.com:8080/bug.cgi?key=1&val=a;2%27> > ); > INSERT INTO testurl (MYID,MYURL) VALUES > (2,'http://foo.com:8080/bug.cgi?key=1&val=a;2'<http://foo.com:8080/bug.cgi?key=1&val=a;2%27> > ); > INSERT INTO testurl (MYID,MYURL) VALUES > (3,'http://foo.com:8080/bug.cgi?key=1&val=a;2'<http://foo.com:8080/bug.cgi?key=1&val=a;2%27> > ); > > What am I doing wrong? > > Rob > > On Sat, Apr 4, 2009 at 10:47 AM, Teijo Aulin <tab...@gm...> wrote: > > Hi > > > > I'm importing a dump from my old mysql db and I've ran into some problems > > with semicolon and Squirrel. The problem is that in the dump (which is > just > > a bunch of insert statements) I have a column that has urls. Some urls > have > > semicolons in them. Each insert statement ends with a semicolon as well. > > > > When I execute the statements one by one, I have no errors. When I select > > all of the lines and run, it fails on the first line that has an url with > a > > semicolon in it (and yes, I can execute that line by itself without > > problems). > > > > Helb ? Thanks. > > > > > ------------------------------------------------------------------------------ > > > > _______________________________________________ > > Squirrel-sql-users mailing list > > Squ...@li... > > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > > > > > -- Cheers, Webmaster http://www.thetabworld.com |
