| Author |
Message |
 Topic: including a linefeed char in an Sql statement |
tessellated
Replies: 14
Views: 5112
|
 Forum: zMUD General Discussion Posted: Sat Mar 05, 2005 4:51 am Subject: including a linefeed char in an Sql statement |
| Thanks, again Dharkael. You rock. And, yeah, generally speaking I'm in full agreement with your sermon so, worry not, it doesn't fall on deaf ears. Had I not been able to solve the problem I would hav ... |
| Topic: including a linefeed char in an Sql statement |
tessellated
Replies: 14
Views: 5112
|
Forum: zMUD General Discussion Posted: Sat Mar 05, 2005 4:18 am Subject: including a linefeed char in an Sql statement |
Woohooooo!! Success! Thank you very much, Darkhael, your suggestions/code got me thinking and I retried your idea with success this time. Here is what I did.
Old code:
...
Sql = %concat( @Sq ... |
| Topic: including a linefeed char in an Sql statement |
tessellated
Replies: 14
Views: 5112
|
Forum: zMUD General Discussion Posted: Sat Mar 05, 2005 3:06 am Subject: including a linefeed char in an Sql statement |
| Hi nexela. I do preface each single quote with another single quote already. I realize you can't tell that from the code posted, but when I build the @object_desc from a trigger I use the %replace to ... |
| Topic: including a linefeed char in an Sql statement |
tessellated
Replies: 14
Views: 5112
|
Forum: zMUD General Discussion Posted: Sat Mar 05, 2005 1:05 am Subject: including a linefeed char in an Sql statement |
Furthermore, if I make the equivalent change to my code that you have in yours (that is, surround the @object_desc with quotes):
...
Sql = %concat( @Sql, ~'"@object_desc"~'~,)
... |
| Topic: including a linefeed char in an Sql statement |
tessellated
Replies: 14
Views: 5112
|
Forum: zMUD General Discussion Posted: Sat Mar 05, 2005 12:59 am Subject: including a linefeed char in an Sql statement |
Hrm. I ran your code on my machine, and it behaves exactly as you say, but that's not the behavior I want. Yes the SQL variable that is sent to the execute method looks like you say, to whit:
INSERT ... |
| Topic: including a linefeed char in an Sql statement |
tessellated
Replies: 14
Views: 5112
|
Forum: zMUD General Discussion Posted: Fri Mar 04, 2005 8:02 pm Subject: including a linefeed char in an Sql statement |
@object_desc contains:
Under a simple hard brown crust, this roll has a moist, chewy centre filled with#flecks of fruits and vegetables.
*note the "#" above actually is my silly representation f ... |
| Topic: including a linefeed char in an Sql statement |
tessellated
Replies: 14
Views: 5112
|
Forum: zMUD General Discussion Posted: Fri Mar 04, 2005 7:28 pm Subject: including a linefeed char in an Sql statement |
| I do use the %char(10) command to insert linefeed characters into the SQL statement as I build it -- or more specifically I use %char() to build a variable of a field which in turn is used to build th ... |
| Topic: including a linefeed char in an Sql statement |
tessellated
Replies: 14
Views: 5112
|
Forum: zMUD General Discussion Posted: Fri Mar 04, 2005 6:18 pm Subject: including a linefeed char in an Sql statement |
Hi again :)
You all have been so very helpful, I have returned yet again with another question. I am building Sql statements inside zMUD and then passing them on to my database via an ADO object.
... |
| Topic: capturing raw ansi text to a variable |
tessellated
Replies: 2
Views: 1403
|
Forum: zMUD General Discussion Posted: Thu Mar 03, 2005 9:36 am Subject: capturing raw ansi text to a variable |
Hi! I want to make a trigger that matches against a line of text example:
Name 'foo'
What's more, I want the "foo" part from above to be saved to a variable including all of the it's raw ansi co ... |
| Topic: Next string vs. special char question |
tessellated
Replies: 3
Views: 1761
|
Forum: zMUD General Discussion Posted: Sat Feb 19, 2005 7:29 am Subject: Next string vs. special char question |
Ok, now I want to test an alias's parameter to see if it begins with the "~" character, but I dont know how to make zmud behave well.
#IF (%begins( %1, ~~)) {#say true} ... |
| Topic: Inserting text into a string that has special chars |
tessellated
Replies: 3
Views: 1781
|
Forum: zMUD General Discussion Posted: Sat Feb 19, 2005 6:23 am Subject: Inserting text into a string that has special chars |
| Awesome, Vijilante. Thank you so much for the very informed and quick reply! |
| Topic: Inserting text into a string that has special chars |
tessellated
Replies: 3
Views: 1781
|
Forum: zMUD General Discussion Posted: Sat Feb 19, 2005 4:52 am Subject: Inserting text into a string that has special chars |
| Ok. I am building sql statements inside zmud that are to be sent to a 3rd party database but am encountering strangeness with zmud's string functions when manipulating parameters that contain special ... |
| |
