RE: Dave Odom was RE: Mark Allen, were you the one that'strying to put numeric datato i5 via ASP???

Hi Vern

It may or may not be rocket science, and in all probability it will turn out to 
be something very simple but I do know it is frustrating as hell. We drag the 
data from the iSeries fine but when we go to send it back is when it goes 
wrong. The code I sent in my original message is where the error occurs. 
Apparently there is nothing in ASP where you can define what a field should be, 
or so I am told.

SQLINSERT="INSERT INTO mylib.myfile (NumField)"
SQLINSERT=SQLINSERT & " VALUES ("
SQLINSERT=SQLINSERT &"'" &NumField &"')"
set connupdate = server.createobject("ADODB.Connection")
connupdate.open "Provider=IBMDA400;Data Source=xxx.xxx.xxx.x;", "ABC", "ABC"
connupdate.execute(SQLINSERT)
connupdate.close

As far as the naming convention goes, if it shows *SQL should it not be *SQL? 
Seems a little strange to me that you can set a value to one thing but it 
displays something totally different.

I know next to nothing about ASP, my friend who does ASP is away until Monday, 
so unfortunately I cannot get into the source. I will get the details from him 
when he gets back.

Steve

-----Oorspronkelijk bericht-----
Van: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]Namens Vernon Hamberg
Verzonden: donderdag 30 november 2006 13:40
Aan: Midrange Systems Technical Discussion
Onderwerp: Re: Dave Odom was RE: Mark Allen, were you the one
that'strying to put numeric datato i5 via ASP???


Steve

This is not rocket science - there is something very simple that is 
not right. Please leave details - what is the final ASP code that 
gave you the SQL0104 message?

We do numerics all the time - ODBC and OLEDB have done it forever - 
you are using the IBMDA400 provider - it works - no problems.

What naming convention are you using - it shows *SQL but maybe it is 
set to *SYS.

Can you debug the ASP code - I know it is similar to VB, but I've 
never worked in it myself. If so, verify what the full SELECT 
statement looks like - something is wrong with it.

So help us help you.

Vern

At 01:34 AM 11/30/2006, you wrote:

C'mon Dave were you just teasing us? Getting our hopes up only to 
have them dashed on the rocks of machine interface incompatability?? ;-)

How do you pass numerics to the iSeries via ASP? We have tried many 
things and none work.

Steve



-----Oorspronkelijk bericht-----
Van: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]Namens Raby, Steve
Verzonden: woensdag 29 november 2006 10:36
Aan: Midrange Systems Technical Discussion
Onderwerp: RE: Mark Allen,were you the one that's trying to put numeric
datato i5 via ASP???


That would be me, how is it done then? Cos we have not got a clue

-----Oorspronkelijk bericht-----
Van: midrange-l-bounces+agnictsr=aeroground.nl@xxxxxxxxxxxx
[mailto:midrange-l-bounces+agnictsr=aeroground.nl@xxxxxxxxxxxx]Namens
Dave Odom
Verzonden: dinsdag 28 november 2006 19:59
Aan: midrange-l@xxxxxxxxxxxx
Onderwerp: Mark Allen, were you the one that's trying to put numeric
datato i5 via ASP???


If so, I do that with an ASP application and it's not a problem.
FWIW.

Take care,

Dave Odom
Arizona
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.