Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

IB 5.6 update text in blob

Posted on 2003-03-20
5
Medium Priority
?
1,423 Views
Last Modified: 2013-12-09
Hello I have a problem with update text in ib 5.6
read is no problem.

first I tried this:
Set RS=myadoDBconn.Execute("UPDATE PMMEMO SET TEKST='jaap'")


I get the error

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[INTERSOLV][ODBC InterBase driver][InterBase]conversion error from string "BLOB"

then I tried this

cmd.SQLType = text
cmd.sql = "UPDATE into table(PMMEMO, TEKST) values (?,?)"
cmd.parameters(0).value = 1
cmd.parameters(1).value = 'This is new blob text' (177)
cmd.ExecSQL

I get the error

Error Type:
Compilatiefout Microsoft VBScript (0x800A03EA)
Syntaxisfout
/call.asp, line 177, column 26

Please help cornee


 
0
Comment
Question by:Cornee
  • 3
  • 2
5 Comments
 
LVL 6

Expert Comment

by:BAlexandrov
ID: 8173531
The right way is with parameters. Read about right use of them in ado reference
0
 

Author Comment

by:Cornee
ID: 8173867

I need more info please ( I am a newbee)


I cant seem to find the info I need about parameters.
where can I find this ADO reference.. MS i guess..
I only find .net stuff

Is it possible at all to insert text in a blob field with ASP?

Do I Need Stored Procedures ?
Do I need UDF or FreeUDFLib or something?

totally lost here....

-Cornee
0
 
LVL 6

Accepted Solution

by:
BAlexandrov earned 225 total points
ID: 8175965
The right way for working with blobs is parametrized query.
It is easy acheivebale with ADO.
See reference for ADO Command Object - it is for working with params, I don't remember now more.
Also chech what OleDB provider you use.
Consider this one
http://www.ibprovider.com/eng/index.html

At this site are also lots of samples with ADO.


Bojidar Alexandrov
0
 

Author Comment

by:Cornee
ID: 8202536
I tried a lot of examples with parametrized but no succes
When i tried the code of www.ibprovider.com i get this error:

the error
ADODB.Parameters (0x800A0E7C)
Parameter object is improperly defined. Inconsistent or incomplete
information was provided.

This is my code:

set cmd=createobject("adodb.command")
cmd.ActiveConnection= myADODBconn
cmd.CommandText = "insert into PMOPDRACHT (CONTACTNAAM) values(?)"

cmd.Parameters.Append cmd.CreateParameter("CONTACTNAAM",VarChar, , , "AAA")

cmd.Execute

This is not a blob field but a varchar, when varchar is working then i go try to insert a blob field.


What is going wrong here??????
Please help me



0
 

Author Comment

by:Cornee
ID: 8252350
It is working with parametrized query and get chunk but thanks!!!!!
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Lotus Notes has been used since a very long time as an e-mail client and is very popular because of it's unmatched security. In this article we are going to learn about  RRV Bucket corruption and understand various methods to Fix "RRV Bucket Corrupt…
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question