Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the 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
Showing results 1 to 8 of 8
Search took 0.00 seconds.
Search: Posts Made By: Imar
Forum: BOOK: Beginning ASP 3.0 March 12th, 2004, 10:26 AM
Replies: 16
Views: 3,493
Posted By Imar
Hi there, The object rsItems is required....

Hi there,

The object rsItems is required. Take a look at this:

rsItems.close
Set rsItems = Nothing
Do While Not rsItems.EOF <--------------------

First you close the object, and then...
Forum: BOOK: Beginning ASP 3.0 March 10th, 2004, 09:28 AM
Replies: 16
Views: 3,493
Posted By Imar
(Is there a bunch of you, or are you pluralis...

(Is there a bunch of you, or are you pluralis majestatis?)

Anyway, what I meant is that with a new user, the rsUsers is EOF, so this code will fail:For each strField in rsUsers.Fields
strName =...
Forum: BOOK: Beginning ASP 3.0 March 10th, 2004, 08:33 AM
Replies: 16
Views: 3,493
Posted By Imar
Yeah, that is the error I'd expect, and was what...

Yeah, that is the error I'd expect, and was what I was referring to in my previous post.

Here's what happens in pseudo code:

Open Recordset
Filter for User
If User Does not Exist Then
Create...
Forum: BOOK: Beginning ASP 3.0 March 10th, 2004, 08:04 AM
Replies: 16
Views: 3,493
Posted By Imar
It seems that the insert works fine now, doesn't...

It seems that the insert works fine now, doesn't it?

Using a Form in Access may not give you the same results as putting in the SQL statement directly in the Query Designer. For example, you...
Forum: BOOK: Beginning ASP 3.0 March 9th, 2004, 10:07 AM
Replies: 16
Views: 3,493
Posted By Imar
What you posted in your previous message is how...

What you posted in your previous message is how you open the connection; not how you create the connection object. You probably have something like
Set objConn =...
Forum: BOOK: Beginning ASP 3.0 March 9th, 2004, 09:23 AM
Replies: 16
Views: 3,493
Posted By Imar
You'll have to help me help you. How about you...

You'll have to help me help you. How about you answer the other questions as well?

Did you copy and paste it in Access?
How do you create your connection?
And what error do you get?

It's...
Forum: BOOK: Beginning ASP 3.0 March 9th, 2004, 08:59 AM
Replies: 16
Views: 3,493
Posted By Imar
From what I can see, your SQL statement looks...

From what I can see, your SQL statement looks fine.

Did you copy and paste it in Access? That's usually the best way to test it out.

What connectionstring are you using? How do you create your...
Forum: BOOK: Beginning ASP 3.0 March 9th, 2004, 08:33 AM
Replies: 16
Views: 3,493
Posted By Imar
Hi there, Can you define "great trouble"? Do...

Hi there,

Can you define "great trouble"? Do you get an error message?

Before you execute insertSQL, write it to the browser window. E.g.:

insertSQL = "bla bla bla"
Response.Write("Sql...
Showing results 1 to 8 of 8

 


All times are GMT -4. The time now is 11:43 PM.


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