Can't Get Text Column

[Guest kelvin]

I am using a simple select statement in DB query module for getting MY SQL DB data.

char field data seems okay but, text field return nothing.

 

Can anyone help!

 

Thx.

[SupportTeam]

Have you tried changing the Text field to be of type VARCHAR(255) and see if that fixes the problem?

[Guest kelvin]

this field contains more than 2000 char!

[SupportTeam]

Another approach would be to do the database query from within a Run VBScript module. There are some examples in the Help file on how to do database queries using VBScript.

[XOLimited]

Another approach would be to do the database query from within a Run VBScript module. There are some examples in the Help file on how to do database queries using VBScript.

 

I seem to be having the same problem, I'm having trouble adapting the example in help.

 

The SQL query gets two results from a database. I have the script able to do that, I'm just unable to get it to assign variables.

 

I know this isn't specifically a question regarding voiceguide, however would be helpful if this workaround did work seeing as the database module is failing here.

 

 

Thanks

 

XO

vbs1.txt

[ktruk]

XO: Just a couple of quick comments on the VBS code you posted above:

 

1. iLineID isn't defined, do: iLineID = $RV-LINEID somewhere at the start.

2. in the SQL query, you may need to add ' (half-quotes) around the $RV (ie: '$RV[Custdata]')

3. you always need to return something to VG for it to act on it. ie: you need to add a vg.Run_ResultReturn iLineId, "xxx" at the end of each branch or end of the script, where xxx = "success" or "1/dbokay" (path num/key) or "" or "fail" (failed/error condition) or "[myrv]{myval}" to set an RV on exit - ie xxx="[sqlSubject]{ & iSubject & "}[sqlContent]{" & iContent & "}".

[SupportTeam]

Looks like there are issues retrieving Text fields from MySQL.

 

Probably best to lookup this informaton in MySQL Help forums as to what is the recommend approach retreiving the Text field from that database.

[XOLimited]

Looks like there are issues retrieving Text fields from MySQL.

 

Probably best to lookup this informaton in MySQL Help forums as to what is the recommend approach retreiving the Text field from that database.

 

I'm using MSSQL 2005 and it's throwing the 40035 error. Still a bit confused with the vbs script.

[ktruk]

XO: ODBC doesn't support retrieving BLOB/Memo type fields with GetRow, you get the error 40035. So this affects MySQL and MSSQL (and anything else using fields bigger than 255 chars). Alternatively, you have to use GetChunk to read in these larger fields. Below is a list of links you can check out. They include details and sample code using this method. You can use these for starters...

 

http://msdn2.microsoft.com/en-us/library/a...089(VS.60).aspx ...

You should not use the GetRows method with long value fields. If you use the GetRows method on an ODBCDirect Recordset object containing long value fields (Memo or Long Binary), you will get an error variant stored in the array where the long value field should be. The array data value will be Error 40035 and the data type Variant.

 

links:

http://support.microsoft.com/kb/153238

How To Use GetChunk and AppendChunk Methods of RDO and ADO Object

 

http://support.microsoft.com/kb/194975/

How To Read and Write BLOBs Using GetChunk and AppendChunk

 

http://support.microsoft.com/kb/200124

Accessing Text or Memo Fields in ASP Returns No Data

 

http://support.microsoft.com/kb/194975/EN-US/

How To Read and Write BLOBs Using GetChunk and AppendChunk

 

http://support.microsoft.com/kb/175239/EN-US/

PRB: 80020009 Error When Retrieving Data from SQL

 

http://msdn2.microsoft.com/en-us/library/ms681747.aspx

GetChunk Method (ADO)

 

http://msdn2.microsoft.com/en-us/library/ms678200.aspx

AppendChunk and GetChunk Methods Example (VB)

 

http://msdn.microsoft.com/library/default....mthgetchunk.asp

GetChunk Method

 

http://support.microsoft.com/kb/103257/EN-US/

ACC: Reading, Storing, & Writing Binary Large Objects (BLOBs)

 

http://msdn.microsoft.com/library/default..../acbachap06.asp

CHAPTER 6 - Working with Records and Fields (see section "The OLE Object and Memo Data Types")

[XOLimited]

XO: ODBC doesn't support retrieving BLOB/Memo type fields with GetRow, you get the error 40035. So this affects MySQL and MSSQL (and anything else using fields bigger than 255 chars). Alternatively, you have to use GetChunk to read in these larger fields. Below is a list of links you can check out. They include details and sample code using this method. You can use these for starters...

 

http://msdn2.microsoft.com/en-us/library/a...089(VS.60).aspx ...

You should not use the GetRows method with long value fields. If you use the GetRows method on an ODBCDirect Recordset object containing long value fields (Memo or Long Binary), you will get an error variant stored in the array where the long value field should be. The array data value will be Error 40035 and the data type Variant.

 

links:

http://support.microsoft.com/kb/153238

How To Use GetChunk and AppendChunk Methods of RDO and ADO Object

 

http://support.microsoft.com/kb/194975/

How To Read and Write BLOBs Using GetChunk and AppendChunk

 

http://support.microsoft.com/kb/200124

Accessing Text or Memo Fields in ASP Returns No Data

 

http://support.microsoft.com/kb/194975/EN-US/

How To Read and Write BLOBs Using GetChunk and AppendChunk

 

http://support.microsoft.com/kb/175239/EN-US/

PRB: 80020009 Error When Retrieving Data from SQL

 

http://msdn2.microsoft.com/en-us/library/ms681747.aspx

GetChunk Method (ADO)

 

http://msdn2.microsoft.com/en-us/library/ms678200.aspx

AppendChunk and GetChunk Methods Example (VB)

 

http://msdn.microsoft.com/library/default....mthgetchunk.asp

GetChunk Method

 

http://support.microsoft.com/kb/103257/EN-US/

ACC: Reading, Storing, & Writing Binary Large Objects (BLOBs)

 

http://msdn.microsoft.com/library/default..../acbachap06.asp

CHAPTER 6 - Working with Records and Fields (see section "The OLE Object and Memo Data Types")

 

Hey, Thanks a lot for your help!