HP3000-L Archives

January 2008, Week 1

HP3000-L@RAVEN.UTC.EDU
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
ODBC (MB Foster) INSERT and Numeric types
From:
Kent Wallace <[log in to unmask]>
Reply To:
Kent Wallace <[log in to unmask]>
Date:
Wed, 2 Jan 2008 11:15:05 -0700
Content-Type:
text/plain
Parts/Attachments:
text/plain (48 lines) 
Everyone

I am using ColdFusion to INSERT a IMAGE detail dataset record using my
MB Foster ODBC.

I get the following error in ClodFusion:

Error Executing Database Query. 	
[Macromedia][SequeLink JDBC Driver][ODBC Socket][ODBCLINK
Host]Unrecognized SQL command 	

<<snipe>>

SQLSTATE	  HY000	
SQL	   <!-- remove extra characters from numbers ---> INSERT INTO
RETURN_D (serv#,STATUS,AMTCHCL,YMDTRANS) VALUES('07347F4640270100','02P
',10400,'20080102') 	
VENDORERRORCODE	  -1	
DATASOURCE	  HP3000Test	

<<End CF  error>> 


1.  The dataset is:

Database: COAL.DATA.AMITEST

    RETURN-D         Detail                  Set# 9
       Entry:                     Offset
          SERV#                X16     1  (!SERV-A)
          STATUS               X10    17
          AMTCHCL              I2     27
          YMDTRANS             X8     31
    Capacity: 13098 (111)  Entries: 0  Highwater: 0  Bytes: 38
>

1.  The field AMTCHCL is an I2, do I need to send a field already
converted to a binary number and not the display number 10400?

Thanks
Kent Wallace




* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

ATOM RSS1 RSS2