Wrox Programmer Forums
| 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 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
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,710
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,710
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,710
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,710
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,710
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,710
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,710
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,710
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

 




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