Wrox Programmer Forums

Need to download code?

View our list of code downloads.

| FAQ | Members List | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #21 (permalink)  
Old September 11th, 2003, 09:32 AM
Authorized User
 
Join Date: Sep 2003
Location: Waco, TX, .
Posts: 40
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to TnTandyO Send a message via Yahoo to TnTandyO
Default

I did note that when I first load the 2nd page it looks right, but there is a error on the page, then when I got to editsave.. the error triangle is gone... but I get an error message!.. line 51
Reply With Quote
  #22 (permalink)  
Old September 11th, 2003, 09:39 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Copenhagen, , Denmark.
Posts: 440
Thanks: 0
Thanked 0 Times in 0 Posts
Default

A small advice for Tandy...

Be carefull with your personal information like your email adress etc. Perhaps it is fictional but spammers enjoy spamming the emails put online.

Jacob.
Reply With Quote
  #23 (permalink)  
Old September 11th, 2003, 09:50 AM
Authorized User
 
Join Date: Sep 2003
Location: Waco, TX, .
Posts: 40
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to TnTandyO Send a message via Yahoo to TnTandyO
Default

Thanks Jacob.. for bringing that to my attention.... duh on me.

Still have a problem with my strSQL???
I fixed the (,) but still....
 strSQL = "UPDATE tblIThelp SET " _
        & "sFname = '" & (Request.Form("Fname")) & "', " _
        & "Lname = '" & (Request.Form("Lname")) & "', " _
        & "Email = '" & (Request.Form("email")) & "', " _
        & "phone = '" & (Request.Form("phone")) & "', " _
        & "dept = '" & (Request.Form("dept")) & "', " _
        & "repeat = '" & (Request.Form("repeat")) & "', " _
        & "priority = '" & (Request.Form("priority")) & "', " _
        & "Comment = '" & (Request.Form("comment")) & "', " _
        & "notes = '" & (Request.Form("notes")) & "', " _
        & "tech = '" & (Request.Form("tech")) & "', " _
        & "date = '" & (Request.Form("date")) & "', " _
        & "time = '" & (Request.Form("time")) & "', " _
        & "solved = '" & (Request.Form("solved")) & "' " _
        & "WHERE (id = " & intID & ")"
Reply With Quote
  #24 (permalink)  
Old September 11th, 2003, 09:55 AM
Imar's Avatar
Wrox Author
Points: 72,073, Level: 100
Points: 72,073, Level: 100 Points: 72,073, Level: 100 Points: 72,073, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

It would be easier if you post the outcome of the query, rather than posting the code.

So, please post the results of the response.Write statement.

Also, before you post the query, paste it in the Microsoft Access Query designer, so you can test it......

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Reply With Quote
  #25 (permalink)  
Old September 11th, 2003, 09:57 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Copenhagen, , Denmark.
Posts: 440
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Check for keywords; you use word like date, time, repeat, priority which could be keywords.

Other things could be difference in the types in the database. You enclose every value in quotes where you might have a representation in your database, which is not string or similar types. E.g. priority could be an integer.

You write Comment with capitalized C where all other names are with lower case letters? is this right?

Jacob.
Reply With Quote
  #26 (permalink)  
Old September 11th, 2003, 09:58 AM
Authorized User
 
Join Date: Sep 2003
Location: Waco, TX, .
Posts: 40
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to TnTandyO Send a message via Yahoo to TnTandyO
Default

Is this what you mean?

I am in editsave UPDATE tblIThelp SET sFname = 'Tandy', Lname = 'Lala', Email = 'some email', phone = 'no phone', dept = 'one', repeat = 'no', priority = 'med', Comment = 'Just testing it help desk program', notes = 'fdgsdg', tech = 'RON', date = '3-21-99', time = '9:33', solved = '' WHERE (id = 1)
Reply With Quote
  #27 (permalink)  
Old September 11th, 2003, 10:03 AM
Imar's Avatar
Wrox Author
Points: 72,073, Level: 100
Points: 72,073, Level: 100 Points: 72,073, Level: 100 Points: 72,073, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

Yes, that's what I meant.

Take Jacob's advice, and look at the datatypes in your database. Also, paste this query in Access. Access is a lot better in debugging your queries than a P2P forum where people can just guess at the things you're doing and the data structure you're using.....

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Reply With Quote
  #28 (permalink)  
Old September 11th, 2003, 10:15 AM
Authorized User
 
Join Date: Sep 2003
Location: Waco, TX, .
Posts: 40
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to TnTandyO Send a message via Yahoo to TnTandyO
Default

Imar,
I'm not sure I understand. Are you politely telling me to bug off? What do you mean by paste this query in access? I've never done that. I guess I can go back to my Acces book.
Thanks for all your help,
 Tandy
Reply With Quote
  #29 (permalink)  
Old September 11th, 2003, 10:21 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Copenhagen, , Denmark.
Posts: 440
Thanks: 0
Thanked 0 Times in 0 Posts
Default

You open your access database and click 'Queries'. Then you create a new one (without wizard) and then you go to the upper left corner, where it says SQL. Click this and you can paste your query.

Jacob.
Reply With Quote
  #30 (permalink)  
Old September 11th, 2003, 10:23 AM
Imar's Avatar
Wrox Author
Points: 72,073, Level: 100
Points: 72,073, Level: 100 Points: 72,073, Level: 100 Points: 72,073, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

Nonono, not at all. I am trying to give you hints on how to improve your debugging abilities:

1. Open Access
2. Open your database in Access
3. Click the Queries tab / category
4. Choose Create query in Design View
5. Close the add table dialog
6. Choose View | SQL View
7. In the textbox that appears paste the update statement you posted (the outcome of Response.Write)
8. Choose: Query | Run


Access will tell you what's wrong with the UPDATE statement.....

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to Edit record right after it was Inserted? aladov ASP.NET 2.0 Professional 4 December 11th, 2007 03:18 PM
Adding a blank record to a grid (in edit-mode) ColSandrs ASP.NET 1.0 and 1.1 Basics 1 December 21st, 2005 08:42 AM
Edit record help dbartelt Access 4 November 9th, 2005 06:02 PM
Update or CancelUpdate without AddNew or Edit ru1 Access 1 October 15th, 2005 02:24 PM
edit, update method life_s Ng ASP.NET 1.0 and 1.1 Basics 5 August 19th, 2003 10:45 PM



All times are GMT -4. The time now is 02:33 AM.


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