ahi vaaa..
gsConnect = " Driver={MySQL};SERVER=localhost;DATABASE=Items;UID =ra;PASSWORD=web"
Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open gsConnect
If Request.Cookies("Counter")=1 then
SQL="INSERT INTO fotos(ITEMID,ITEMOWNER,CATEGORYID,"&Imagen&","&Com entario&") VALUES("&Request.Cookies("ItemID")&","&Request.Coo kies("ItemOwner")&","&Request.Cookies("categoryId" )&",'"&NombreFichero& "','"&up.Form("nombre")&"')"
' SQL2="UPDATE auctions SET IMAGEURL='"&NombreFichero&"' WHERE ITEMID="&Request.Cookies("ItemID")
RESPONSE.WRITE Request.Cookies("ItemID")
SQL2= "UPDATE auctions SET IMAGEURL='" & NombreFichero & "' WHERE ITEMID="& Request.Cookies("ItemID") &";"
'response.write SQL
response.write SQL2
GobjConnect.Execute(SQL2)
Else
RESPONSE.WRITE Request.Cookies("Ultimo")
SQL="UPDATE fotos SET "&Imagen&"='"&NOmbreFichero& "',"&Comentario&"='"&up.Form("nombre")&"' WHERE ID="&Request.Cookies("Ultimo") &";"
End If
'Call OpenDBConn
RESPONSE.WRITE SQL
GobjConnect.Execute(SQL)
SQL_ULTIMO="SELECT * FROM fotos ORDER BY ID DESC"
SET RS_ULTIMO=GobjConnect.Execute(SQL_ULTIMO)
Response.Cookies("Ultimo")=RS_ULTIMO("ID")
y nuevamente me manda:
Se requiere un objeto: ''
/asp/CR-RealEstate/real-estate/uptest.asp, line 108
y esta línea es:
GobjConnect.Execute(SQL)
con ese RESPONSE.WRITE Request.Cookies("Ultimo")
que introduje o sin ese, me da el mismo error!
