|
 |
asp_databases thread: Carrier Return... Part 2.
Message #1 by "Sebastian Pittari" <mailing@3...> on Thu, 8 Jun 2000 16:45:08 -0300
|
|
Hi,
For those that gaves me the tip of REPLACE command, thanks. (I didn't know
that command, by the way... is there any resource on the net, with a list of
all VBScript commands, functions, objects, methods, events, etc?)
Now, I have a new one, directly related with the previous one.
I had the CRLF replaced by <BR>. Ok!
But, my table had TEXT fields, remember? Well, my recordset can't get the
data on those fields.
I could get errors from ODBC or maybe an empty set.
I read some papers and this seems to be a design problem on the ODBC core,
related with the long amount of data or data type (TEXT, NTEXT and MEMO
types).
Any suggestion to solve this, I mean, any different to "Change the Data
Type".
Thanks again.
Sebs.
Message #2 by "Ken Schaefer" <ken.s@a...> on Fri, 9 Jun 2000 18:23:02 +1000
|
|
You can download the VBScript documentation in Help file format here:
http://msdn.microsoft.com/scripting/vbscript/download/vbsdoc.exe
The problems you are having with text/memo fields can be solved by following
these steps:
a) Don't use ODBC - use OLEDB instead
b) Never do SELECT *, always enumerate all the fields that you want to use
c) Always SELECT your text/memo fields *last*, and in the order that they
are in the database eg:
Access example:
field1 - autonumber
field2 - text
field3 - memo
field4 - text
field 5 - memo
Your SELECT statement should read:
SELECT field1, field2, field4, field3, field5 FROM table1
Once you have opened the recordset, assign the value of the text/memo field
to a local variable:
strField3 = objRS("field3")
strField5 = objRS("field5")
and use the local variables whenever you need to do something with those
database fields.
That will solve you problem. There is a MS KB article on this, but I can't
seem to find it anymore.
Cheers
Ken
----- Original Message -----
From: "Sebastian Pittari"
To: "ASP Databases" <asp_databases@p...>
Sent: Friday, June 09, 2000 5:45 AM
Subject: [asp_databases] Carrier Return... Part 2.
> Hi,
>
> For those that gaves me the tip of REPLACE command, thanks. (I didn't know
> that command, by the way... is there any resource on the net, with a list
of
> all VBScript commands, functions, objects, methods, events, etc?)
>
> Now, I have a new one, directly related with the previous one.
>
> I had the CRLF replaced by <BR>. Ok!
>
> But, my table had TEXT fields, remember? Well, my recordset can't get the
> data on those fields.
>
> I could get errors from ODBC or maybe an empty set.
>
> I read some papers and this seems to be a design problem on the ODBC core,
> related with the long amount of data or data type (TEXT, NTEXT and MEMO
> types).
>
> Any suggestion to solve this, I mean, any different to "Change the Data
> Type".
>
>
> Thanks again.
>
> Sebs.
Message #3 by "Pat Waddington" <paw@s...> on Fri, 9 Jun 2000 20:59:47 +0100
|
|
Try microsft.com - I'm fairly sure I found one there
Pat
----- Original Message -----
From: Sebastian Pittari
To: ASP Databases <asp_databases@p...>
Sent: Thursday, June 08, 2000 8:45 PM
Subject: [asp_databases] Carrier Return... Part 2.
> Hi,
>
> For those that gaves me the tip of REPLACE command, thanks. (I didn't know
> that command, by the way... is there any resource on the net, with a list
of
> all VBScript commands, functions, objects, methods, events, etc?)
>
> Now, I have a new one, directly related with the previous one.
>
> I had the CRLF replaced by <BR>. Ok!
>
> But, my table had TEXT fields, remember? Well, my recordset can't get the
> data on those fields.
>
> I could get errors from ODBC or maybe an empty set.
>
> I read some papers and this seems to be a design problem on the ODBC core,
> related with the long amount of data or data type (TEXT, NTEXT and MEMO
> types).
>
> Any suggestion to solve this, I mean, any different to "Change the Data
> Type".
>
> Thanks again.
>
> Sebs.
Message #4 by smartin@c... on Sat, 10 Jun 2000 13:53:57 -0400
|
|
Should be on all ASP developers' bookmark lists...
http://msdn.microsoft.com/scripting/
Complete language references for VBScript and JScript.
> -----Original Message-----
> From: Pat Waddington
> Sent: Friday, June 09, 2000 4:00 PM
> To: ASP Databases
> Subject: [asp_databases] Re: Carrier Return... Part 2.
>
>
> Try microsft.com - I'm fairly sure I found one there
>
> Pat
> ----- Original Message -----
> From: Sebastian Pittari
> To: ASP Databases <asp_databases@p...>
> Sent: Thursday, June 08, 2000 8:45 PM
> Subject: [asp_databases] Carrier Return... Part 2.
>
>
> > Hi,
> >
> > For those that gaves me the tip of REPLACE command, thanks.
> (I didn't know
> > that command, by the way... is there any resource on the
> net, with a list
> of
> > all VBScript commands, functions, objects, methods, events, etc?)
> >
> > Now, I have a new one, directly related with the previous one.
> >
> > I had the CRLF replaced by <BR>. Ok!
> >
> > But, my table had TEXT fields, remember? Well, my recordset
> can't get the
> > data on those fields.
> >
> > I could get errors from ODBC or maybe an empty set.
> >
> > I read some papers and this seems to be a design problem on
> the ODBC core,
> > related with the long amount of data or data type (TEXT,
> NTEXT and MEMO
> > types).
> >
> > Any suggestion to solve this, I mean, any different to
> "Change the Data
> > Type".
> >
> > Thanks again.
> >
> > Sebs.
> ---
|
|
|
View Cart
