|
Hi SteveWhen I said it shows *SQL, I meant that your statement was using SQL naming - lib.file instead of lib/file. There is an attribute of the connection that you can use to set which naming convention to use - I forget what the default is. Your code does explicitly set the naming convention.
midrange.com
As to the statement, here is what it is after resolving variables and all
INSERT INTO mylib.myfile (NumField) VALUES ('123456')
If NumField in myfile is numeric, then this will not work, because
you are putting a character string into a numeric field. Get rid of
both apostrophes. In particular, change
SQLINSERT=SQLINSERT &"'" &NumField &"')" to SQLINSERT=SQLINSERT &NumField &")" HTH Vern At 07:07 AM 11/30/2006, you wrote:
Hi VernIt 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.closeAs 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. -- 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.
