I'm trying to use MYSQLMan to import/replace part of a table of data that I extracted from LinksSQL2 using the export table program built within the LINKSQL2 program.

When LinksSQL2 exports a table, it adds the following internal variable %0a to represent a line end within a field. What exactly do I change that to so that MYSQLMan will read that as a line end? If I use it as is my paragraphs within a large text field are destroyed...

Thanks!

Dennis
Dennis
http://www.genealogysurnames.com/

\n

...or, in the database you could try running;

UPDATE lsql_Links SET Description = REPLACE(Description,'%0a','\n');

Hope that helps :)

Cheers

Andy (mod)
andy@ultranerds.co.uk

---

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates