Passing Parameters to a query

[Johnd]

I am running into an issue when I try to write more than 1024 characters to
a memo field. Apparantly the odbc connection I am using does not permit
literals to be larger that 1024 characters. This Memo filed can take
virtually infinate data, so the solution seems to be use parameters. My
problem is I have never heard of this and need this to work ASAP. Does
anyone have a simple example of how Parameters work using ASP?

[Bob Barrows]

Johnd wrote:

I am running into an issue when I try to write more than 1024
characters to a memo field. Apparantly the odbc connection I am
That's your first problem. You should be using the native Jet OLEDB
provider. See www.able-consulting.com/ado_conn.htm for examples.
using does not permit literals to be larger that 1024 characters.
This Memo filed can take virtually infinate data, so the solution
seems to be use parameters. My problem is I have never heard of this
and need this to work ASAP. Does anyone have a simple example of how
Parameters work using ASP?

http://www.google.com/groups?hl=en&l...phx.gbl&rnum=6

HTH,
Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Johnd]

Thanks Bob but heres a little more detail.

I am using Advantage server 6.2

here is my code:
// Set Conn = Server.CreateOb ject("ADODB.Con nection")
// Conn.Open "DSN=LocalO P"
// strQuery = "insert into NCRheadcomments (hdrcomid, headerid, comdate,
userid, comments, comtime)" &_
// "values(10084,1 0080, '" & FormatDateTime( Date(), VBshortDate ) &_
// "', '" & session("Curren tUser") & "', '" & CurrentComment & "', '" &
time & "')"
// Set objRS = Conn.Execute(st rQuery)
// conn.close
My problem is CurrentComment is larger than 1024 characters. Is there a way
to get this to work without using a saved query as I do not believe that is
available to my at this time.

John,

"Bob Barrows" <re******@NOyah oo.SPAMcom> wrote in message
news:uX******** ******@TK2MSFTN GP09.phx.gbl...

Johnd wrote:

I am running into an issue when I try to write more than 1024
characters to a memo field. Apparantly the odbc connection I am
That's your first problem. You should be using the native Jet OLEDB
provider. See www.able-consulting.com/ado_conn.htm for examples.

using does not permit literals to be larger that 1024 characters.
This Memo filed can take virtually infinate data, so the solution
seems to be use parameters. My problem is I have never heard of this
and need this to work ASAP. Does anyone have a simple example of how
Parameters work using ASP?

http://www.google.com/groups?hl=en&l...phx.gbl&rnum=6
HTH,
Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Bob Barrows]

Johnd wrote:

Thanks Bob but heres a little more detail.

I am using Advantage server 6.2

here is my code:
// Set Conn = Server.CreateOb ject("ADODB.Con nection")
// Conn.Open "DSN=LocalO P"
// strQuery = "insert into NCRheadcomments (hdrcomid, headerid,
comdate,
userid, comments, comtime)" &_
// "values(10084,1 0080, '" & FormatDateTime( Date(), VBshortDate
) &_ // "', '" & session("Curren tUser") & "', '" &
CurrentComment & "', '" &
time & "')"
// Set objRS = Conn.Execute(st rQuery)
Why are you creating a recordset object to run a non-records-returning
query? Just do this:
Conn.Execute strQuery,,129

// conn.close
My problem is CurrentComment is larger than 1024 characters. Is
there a way
to get this to work without using a saved query as I do not believe
that is
available to my at this time.

Why not? According to their website, Advantage supports stored procedures.

You will likely need to use AppendChunk
(http://msdn.microsoft.com/library/en...damth01_3.asp), a
Command object and a Parameter object. Check out the example in that link.

I'm sorry but, due to my non-familiarity with Advantage, I am not going to
be able to get into specifics. Have you tried their support system?

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Johnd]

Thankyou for taking the time to reply on this issue. I realize this is not
the best group for this post, but I can't find any leads elsewhere. Also I
was hoping that this waas a limitation of SQL and therefore best handled
here. I have looked for stored procedures and been told that they are not
supported in the Novell version of advanage 6.2 I will look further into
it. In the mean time I will look at the "chunk" solution you have suggested
and post my results for future reference.

John,

BTW. It never occured to me to just execute the object Conn.Execute
strQuery,,129

"Bob Barrows" <re******@NOyah oo.SPAMcom> wrote in message
news:ON******** ******@TK2MSFTN GP10.phx.gbl...

Johnd wrote:

Thanks Bob but heres a little more detail.

I am using Advantage server 6.2

here is my code:
// Set Conn = Server.CreateOb ject("ADODB.Con nection")
// Conn.Open "DSN=LocalO P"
// strQuery = "insert into NCRheadcomments (hdrcomid, headerid,
comdate,
userid, comments, comtime)" &_
// "values(10084,1 0080, '" & FormatDateTime( Date(), VBshortDate
) &_ // "', '" & session("Curren tUser") & "', '" &
CurrentComment & "', '" &
time & "')"
// Set objRS = Conn.Execute(st rQuery)

Why are you creating a recordset object to run a non-records-returning
query? Just do this:
Conn.Execute strQuery,,129

// conn.close
My problem is CurrentComment is larger than 1024 characters. Is
there a way
to get this to work without using a saved query as I do not believe
that is
available to my at this time.

Why not? According to their website, Advantage supports stored procedures.

You will likely need to use AppendChunk
(http://msdn.microsoft.com/library/en...damth01_3.asp), a
Command object and a Parameter object. Check out the example in that link.

I'm sorry but, due to my non-familiarity with Advantage, I am not going to
be able to get into specifics. Have you tried their support system?

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Ray at]

"Bob Barrows" <re******@NOyah oo.SPAMcom> wrote in message
news:ON******** ******@TK2MSFTN GP10.phx.gbl...

Why are you creating a recordset object to run a non-records-returning
query? Just do this:
Conn.Execute strQuery,,129

What's this Bob? Is that a numeric value of 129 instead of defining a
constant? :P

Ray at work

[Bob Barrows]

Ray at <%=sLocation% > wrote:

"Bob Barrows" <re******@NOyah oo.SPAMcom> wrote in message
news:ON******** ******@TK2MSFTN GP10.phx.gbl...

Why are you creating a recordset object to run a
non-records-returning query? Just do this:
Conn.Execute strQuery,,129

What's this Bob? Is that a numeric value of 129 instead of defining a
constant? :P

I was going to tell him to go look it up if he asked ;-)
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Dave Anderson]

"Ray at <%=sLocation% >" wrote:

What's this Bob? Is that a numeric value of 129 instead of
defining a constant?

What would he call it? adCmdTextExecut eNoRecords ?
--
Dave Anderson

Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms. Please do not contact
me directly or ask me to contact you directly for assistance. If your
question is worth asking, it's worth posting.

[Ray at]

adChar?

Ray at work

"Dave Anderson" <GT**********@s pammotel.com> wrote in message
news:uR******** ******@tk2msftn gp13.phx.gbl...

"Ray at <%=sLocation% >" wrote:

What's this Bob? Is that a numeric value of 129 instead of
defining a constant?
What would he call it? adCmdTextExecut eNoRecords ?
--
Dave Anderson

Unsolicited commercial email will be read at a cost of $500 per message.

Use of this email address implies consent to these terms. Please do not contact me directly or ask me to contact you directly for assistance. If your
question is worth asking, it's worth posting.

[Johnd]

If you guys put as much effort into helping people as you do into you
humour, I think there may be hope for some of us rookies :-)
"Ray at <%=sLocation% >" <myfirstname at lane34 dot com> wrote in message
news:%2******** ********@TK2MSF TNGP12.phx.gbl. ..

adChar?

Ray at work

"Dave Anderson" <GT**********@s pammotel.com> wrote in message
news:uR******** ******@tk2msftn gp13.phx.gbl...

"Ray at <%=sLocation% >" wrote:

What's this Bob? Is that a numeric value of 129 instead of
defining a constant?

What would he call it? adCmdTextExecut eNoRecords ?
--
Dave Anderson

Unsolicited commercial email will be read at a cost of $500 per message.

Use

of this email address implies consent to these terms. Please do not

contact

me directly or ask me to contact you directly for assistance. If your
question is worth asking, it's worth posting.