asp_databases thread: Text data passed into database
Message #1 by "sunil ferrao" <ltsbbank@e...> on Wed, 28 Nov 2001 06:36:57
|
|
I have a small problem. I am in the process of updating an application
currently on interbase to SQL.
I have written procedures which work fine.
Using asp to display the data in the SQL server I show a record which
contains a text field This is not a problem.
What I have to do is update this record in the Asp Page and then post this
record. As only a couple of fields are changing I use the Update option in
the SQL Procedure. I tried this in the Query Viewer it worked fine.
On the Asp page I use ADO to connect to SQL. Here as I am passing
parameters I do not know how to define the text filed in the parameter.
Can Anyone help?
Is there a better way?
Message #2 by David Cameron <dcameron@i...> on Wed, 28 Nov 2001 17:36:30 +1100
|
|
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C177D7.03D03DDC
Content-Type: text/plain
With the following information we might be able to help:
1. What database you are using.
2. The code snipped that is causing the trouble.
regards
David Cameron
nOw.b2b
dcameron@i...
-----Original Message-----
From: sunil ferrao [mailto:ltsbbank@e...]
Sent: Wednesday, 28 November 2001 4:37 PM
To: ASP Databases
Subject: [asp_databases] Text data passed into database
I have a small problem. I am in the process of updating an application
currently on interbase to SQL.
I have written procedures which work fine.
Using asp to display the data in the SQL server I show a record which
contains a text field This is not a problem.
What I have to do is update this record in the Asp Page and then post this
record. As only a couple of fields are changing I use the Update option in
the SQL Procedure. I tried this in the Query Viewer it worked fine.
On the Asp page I use ADO to connect to SQL. Here as I am passing
parameters I do not know how to define the text filed in the parameter.
Can Anyone help?
Is there a better way?
$subst('Email.Unsub')
Read the future with ebooks at B&N
http://service.bfast.com/bfast/click?bfmid=2181&sourceid=38934667&categoryid
=rn_ebooks
Message #3 by "Ken Schaefer" <ken@a...> on Wed, 28 Nov 2001 17:47:13 +1100
|
|
adLongVarChar
adLongVarWChar
?
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "sunil ferrao" <ltsbbank@e...>
Subject: [asp_databases] Text data passed into database
: I have a small problem. I am in the process of updating an application
: currently on interbase to SQL.
:
: I have written procedures which work fine.
:
: Using asp to display the data in the SQL server I show a record which
: contains a text field This is not a problem.
:
: What I have to do is update this record in the Asp Page and then post this
: record. As only a couple of fields are changing I use the Update option in
: the SQL Procedure. I tried this in the Query Viewer it worked fine.
: On the Asp page I use ADO to connect to SQL. Here as I am passing
: parameters I do not know how to define the text filed in the parameter.
:
: Can Anyone help?
:
: Is there a better way?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|
View Cart
