Re: Writing a GUID to a SQL table



Phil Kelly wrote:
> Hi and thanks for your response!
>
> The response.write displays a perfectly formed GUID, no more.

You are answering the wrong question.
We cannot debug a sql statement without knowing what it is. Seeing the code
that generates the statement is only a small part of the story. We need to
see the result of "Response.Write writeToTable "

Also, we need to know the type and version of the database you are using. I
strongly suspect that it is SQL Server, but I dislike guessing ;-)

You may find these posts helpful:
http://mvp.unixwiz.net/techtips/sql-injection.html
http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=23

http://groups-beta.google.com/group/microsoft.public.inetserver.asp.db/msg/72e36562fee7804e

http://tinyurl.com/jyy0

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.



Relevant Pages

  • Re: Writing a GUID to a SQL table
    ... Microsoft OLE DB Provider for SQL Server error '80040e14' ... >> The response.write displays a perfectly formed GUID, ... > We cannot debug a sql statement without knowing what it is. ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • Re: Problems when passing a sql statement containing non-english characters to a ADO.Recordset o
    ... The SQL statement I used is ... registered charsets. ... The Response object has an Encoding property which you can use to set the ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • Re: Expression Builder
    ... Open the query in Design View. ... This is what the SQL statement shows: ... This email account is my spam trap so ...
    (microsoft.public.access.queries)
  • Re: Expression Builder
    ... Open the query in Design View. ... This is what the SQL statement shows: ... This email account is my spam trap so ...
    (microsoft.public.access.queries)
  • Re: Expression Builder
    ... Open the query in Design View. ... Could you show us the sql statement for your query? ... This email account is my spam trap so ...
    (microsoft.public.access.queries)

Loading