#8 Exclamation mark

[Julián Muńoz]

By: jfrank5760 ( John Frank ) Exclamation mark
2001-02-21 23:42
When updating or inserting records into a database, if
a field contains an exclamation mark, (!) it is ignored
and not inserted. This is true no matter what type of
database engine I'm using and no matter whether I use
the socktest utility or PHP. The event log shows the
exclamation mark has been dropped from the query string.

Is this perhaps a bug or a limitation of XML or
something like that?

I'm using the ODBC socket server's native XML format.
Would using the MS format change this?
I can't really use MS format because one of the
databases I must deal with doesn't seem to be able to
handle it; I get truncated results.

Thanks for a superb product.

By: teamfxml ( Team FXML )
RE: Exclamation mark
2001-03-04 19:16
Hi there,
Thanks for this bug report. Can you please post the
event log error you are receiving? Also, for faster
follwups please cc me at fxml@excite.com on any
messages posted.

Thanks,

Tyler

By: jfrank5760 ( John Frank )
RE: Exclamation mark
2001-03-05 19:06
Hi Tyler;
Here is a copy of what I see in the Event Log. The
original SQL statement I entered was:

INSERT INTO passwords (Machine, Userid, Password,
Comments) VALUES ('linux', 'johnf', 'secret', 'Insert a
bang!')

Note the bang. As you can see below, the bang does not
appear in the event viewer and is not inserted into the
database field.

The description for Event ID ( 0 ) in Source (
ODBCSocketServer ) cannot be found. The local computer
may not have the necessary registry information or
message DLL files to display messages from a remote
computer. The following information is part of the
event: ReadWriteSocket reports executing SQL:INSERT
INTO passwords (Machine, Userid, Password, Comments)
VALUES ('linux', 'johnf', 'secret', 'Insert a bang').

I used socktest.exe for this test.

Thanks, John.

By: teniviki ( me )
RE: Exclamation mark
2001-12-05 16:26
If you look in fxml.cpp, the parser is coded to strip
out all ? and ! as comments. Using the ms DTD would
make no difference. This is troublesome for databases
like foxpro where you specify databases in
datbase!table form. Of course you cant pull from more
than one DSN (aka database) with odbcsocketserver
anyways, because you can only connect to one DSN at a
time. I've made a very simple hack around this for my
purposes, but I'd like to see the ability to connect to
more than one DSN in future versions if possible.