Wrox Programmer Forums
|
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 16th, 2007, 03:45 PM
Friend of Wrox
 
Join Date: May 2006
Posts: 643
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I have been quoted!!!! Now I can go to my grave peacefully. Thanks dparsons. I have always admired your posts for their reasonable approach and patience. That is particularly evident in this thread! Kudos.

phantom: What dparsons is saying is correct - you really need to learn some basics. Developers in these forums can help, but they really can't debug your code. What I think dparsons is saying - is that now is the time in your career that you must learn the techniques of debugging. The techniques you have to learn include things like how to isolate a problem, how to use reductive thinking, how to decompose a problem, how to unit test, how to read error messages, how to search for information on the internet, how to write helper functions and tracing into your application, and so on. There is a lot to learn, but it is fun and will turn you into a competent developer.


Woody Z
http://www.learntoprogramnow.com
 
Old February 16th, 2007, 03:50 PM
Authorized User
 
Join Date: Feb 2007
Posts: 32
Thanks: 0
Thanked 0 Times in 0 Posts
Default

yeah i know what u mean ...i looked up for that one ..
but i'm not able to find out whats wrong with this ...plz help me out with that one ..

I'm getting this error
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
Unknown column 'abcd' in 'field list'
/save_inc.asp, line 46

for i=0 to (sSim_num-1)
        sql = "insert into srpcSims values (null,"&projID&",'"&sSim_host(i)&"','"&sSim_dir(i) &"','"&sSim_ip(i)&"',"&sSim_suid(i)&","&sSim_numBE S(i)&","&sSim_startPIN(i)&","&sSim_numPIN(i)&","&s Sim_dupPIN&",'"&sSim_authKey(i)&"','"&sSim_mthpyld size(i)&"','"&sSim_contype(i)&"')"
            db_conn.execute(sql)
Plz help ....

 
Old February 16th, 2007, 04:06 PM
Friend of Wrox
 
Join Date: May 2006
Posts: 643
Thanks: 0
Thanked 0 Times in 0 Posts
Default

The error message tells you exactly what the problem is.
To see your problem you need to replace the db_conn.execute with code to 'response.write' your sql statement:

Response.Write sql
Response.End

This will print your sql statement to the browser so you can see where your problem is.

Woody Z
http://www.learntoprogramnow.com
 
Old February 16th, 2007, 10:50 PM
Wrox Author
 
Join Date: Oct 2005
Posts: 4,104
Thanks: 1
Thanked 64 Times in 64 Posts
Send a message via AIM to dparsons
Default

Woody you are quite welcome and thank you for the kind words, it is much appreciated.

phantom, here is a hint: it has to do with your sql statement.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html





Similar Threads
Thread Thread Starter Forum Replies Last Post
plz.....plz solve out my problem.... kethireddy435 ASP.NET 1.x and 2.0 Application Design 1 October 4th, 2007 12:56 PM
plz help me ASAP developer.ibm Java Basics 4 August 22nd, 2007 12:32 PM
Need Help ASAP coding C# 1 June 6th, 2007 12:41 AM
Plz Help ASAP phantom3008 Classic ASP Basics 3 March 2nd, 2007 05:55 PM
HELP! HELP! Please ASAP iamucha Access 2 March 25th, 2004 11:42 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.