[WebDNA] inputed text getting scrambled up in DB
This WebDNA talk-list message is from 2012
It keeps the original formatting.
numero = 108379
interpreted = N
texte = Hey everybody, I'm experiencing something really strange saving text (inputed from a = textarea) into a database. The textarea uses [input] tags and is saved = to the Db with [url] wrappers. I found this before but it wasn't = something I had to figure out at the moment. Now, I have a client = complaining about having this problem (potentially with only a specific = textarea for a specific record??). Bascially, if I enter: [snip] hello everybody 01/30/2012 - I do something here 02/01/2012 - I did something else [/snip] this gets saved to the database: [snip] hello everybody 01/30/2012 - I do something here 02/01/2012 I did somethigg else [/snip] save it again, and I get: [snip] hello everybody 01/30/2012 - I do something here 02/01/2012 I did somethigg esee [/snip] When I view the actual [url]'ed string that's being saved, its 100% = correct. But what is in the database is all jumbled. You can test it = here...http://medequipsol.kazwebworks.com/admin/sandbox.dna Strange thing is, I have a database admin tool that writes to it just = fine. I'll try to isolate and recreate that logic, and then include it = in another email. This is a v7 site BTW. here is the full code for this example though: [code] [text]var_instant=3D499[/text] [showif [nowConfiguring]=3DT] this is what was posted..
this is what is entered into the database..
[replace = db=3D/admin/dbs/client/purchase_orders.db&eqIDdatarq=3D[var_instant]]field= 5=3D[url][inputNotes][/url][/replace] [/showif]
Enter text here:
[/code]=
Associated Messages, from the most recent to the oldest:
Hey everybody, I'm experiencing something really strange saving text (inputed from a = textarea) into a database. The textarea uses
[input] tags and is saved = to the Db with
[url] wrappers. I found this before but it wasn't = something I had to figure out at the moment. Now, I have a client = complaining about having this problem (potentially with only a specific = textarea for a specific record??). Bascially, if I enter: [snip] hello everybody 01/30/2012 - I do something here 02/01/2012 - I did something else [/snip] this gets saved to the database: [snip] hello everybody 01/30/2012 - I do something here 02/01/2012 I did somethigg else [/snip] save it again, and I get: [snip] hello everybody 01/30/2012 - I do something here 02/01/2012 I did somethigg esee [/snip] When I view the actual
[url]'ed string that's being saved, its 100% = correct. But what is in the database is all jumbled. You can test it = here...http://medequipsol.kazwebworks.com/admin/sandbox.dna Strange thing is, I have a database admin tool that writes to it just = fine. I'll try to isolate and recreate that logic, and then include it = in another email. This is a v7 site BTW. here is the full code for this example though: [code]
[text]var_instant=3D499[/text] [showif [nowConfiguring]=3DT] this is what was posted..
this is what is entered into the database..
[replace = db=3D/admin/dbs/client/purchase_orders.db&eqIDdatarq=3D[var_instant]]field= 5=3D
[url][inputNotes][/url][/replace] [/showif]
Enter text here:
[/code]=
aaronmichaelmusic@gmail.com
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Sendmail Recipients (2001)
Last Record not recognized? (1999)
Credit Card Number checking (1997)
reverse of math value... (2004)
[WebDNA] Searching and replacing in another file (2013)
multiple record replace (2001)
FileMaker and WebCat - .hdr OK Merge not OK (1999)
[WebDNA] Numerous signal SIGSEGV upgrading to 8.1 or 8.2? (2016)
WC2f3 (1997)
[LOOKUP] (1997)
IIS4/IIS3 and WebCatalog registry settings (1998)
$flushdatabases question ... (1998)
MATH TIME (1997)
[OT] Mozilla | Was: R.I.P. Netscape (2003)
Triggers and coupons (two questions) (2003)
File Upload (1997)
Another question (1997)
Possible Bug in 2.0b15.acgi (1997)
NT vs Mac (1997)
Redirecting some image requests ... (2003)