Forums
This topic is locked
Problems Writing out ASP SQL Statement
Posted 01 Mar 2008 19:28:56
1
has voted
01 Mar 2008 19:28:56 Gavin Harrison posted:
The problem that i have is since i upgraded to Dreamweaver CS3 is that i am now unable to write out the SQL statement from the following code <pre id=code><font face=courier size=2 id=code>
Dim MM_editCmd
Set MM_editCmd = Server.CreateObject ("ADODB.Command"
MM_editCmd.ActiveConnection = MM_connInternal_STRING
MM_editCmd.CommandText = "INSERT INTO tblUser (txtName) VALUES (?)"
MM_editCmd.Prepared = true
MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param3", 202, 1, 255, Request.Form("Name") ' adVarWChar
MM_editCmd.Execute
MM_editCmd.ActiveConnection.Close
</font id=code></pre id=code>
i have tried
<pre id=code><font face=courier size=2 id=code>
response.Write(MM_editCmd.ActiveConnection)
</font id=code></pre id=code>
It comes back with a ? instead of the actual value
I also tried using
<pre id=code><font face=courier size=2 id=code>
response.Write(MM_editCmd)
</font id=code></pre id=code>
but it just comes back with an error Saying
Response object error 'ASP 0185 : 8002000e'
Missing Default Property
/default.asp, line 0
A default property was not found for the object.
Thanks for any help in advance
Gavin