|
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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.