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 25 of 111
Search took 0.03 seconds.
Search: Posts Made By: KenSchaefer
Forum: ASP Forms June 6th, 2004, 05:34 AM
Replies: 2
Views: 1,790
Posted By KenSchaefer
You want to do this in server-side code? <% Dim...

You want to do this in server-side code?

<%
Dim strCountry
strCountry = Request.Form("radCountry")

If Len(strCountry) > 0 then
†††Response.Write("You selected: " & strCountry & "<br />" &...
Forum: ASP Forms June 6th, 2004, 05:28 AM
Replies: 1
Views: 2,480
Posted By KenSchaefer
You will need to talk to your server...

You will need to talk to your server administrator about what user identity IIS is impersonating in order to run the code you are using. For example, if it is impersonating IUSR_<machinename> then...
Forum: ASP Forms June 6th, 2004, 05:24 AM
Replies: 2
Views: 812
Posted By KenSchaefer
After you disable "Show Friendly HTTP Errors",...

After you disable "Show Friendly HTTP Errors", please reload the page, and post the exact error message you now see.

Cheers
Ken

Microsoft MVP - Windows Server (IIS)
www.adOpenStatic.com
Forum: ASP Forms June 6th, 2004, 05:23 AM
Replies: 1
Views: 974
Posted By KenSchaefer
You need an SMTP server to receive mail, not a...

You need an SMTP server to receive mail, not a web server. A web server serves web pages. An SMTP server is used for sending and receiving mail.

Cheers
Ken

Microsoft MVP - Windows Server...
Forum: ASP.NET 1.0 and 1.1 Basics March 19th, 2004, 11:22 PM
Replies: 4
Views: 928
Posted By KenSchaefer
Can you please post the relevant code you are...

Can you please post the relevant code you are using?

Cheers
Ken

Microsoft MVP - Windows Server (IIS)
www.adOpenStatic.com
Forum: ASP Forms March 19th, 2004, 11:18 PM
Replies: 1
Views: 2,692
Posted By KenSchaefer
If the second button doesn't actually do a...

If the second button doesn't actually do a submit, then make it:
<input type="button"> not <input type="submit">

To set the hidden input field *client side* (i.e. avoiding a round trip to the...
Forum: Classic ASP Databases March 19th, 2004, 11:14 PM
Replies: 5
Views: 1,651
Posted By KenSchaefer
strSQL = "UPDATE myTable SET myField = NULL WHERE...

strSQL = "UPDATE myTable SET myField = NULL WHERE RecordID = 1"
objConn.Execute strSQL,,adCmdText+adExecuteNoRecords

Cheers
Ken

Microsoft MVP - Windows Server (IIS)
www.adOpenStatic.com
Forum: Classic ASP Databases March 19th, 2004, 11:13 PM
Replies: 2
Views: 899
Posted By KenSchaefer
You need to define "TOP 10", eg, the first 10...

You need to define "TOP 10", eg, the first 10 records entered, the first 10 alphabetically by name etc.

SELECT TOP 10 UserFirstName, UserSurname FROM myTable ORDER BY UserSurname

the "top 10" is...
Forum: ASP Pro Code Clinic February 23rd, 2004, 09:44 AM
Replies: 3
Views: 1,012
Posted By KenSchaefer
My suggestion: Instatiate the class on each page...

My suggestion:
Instatiate the class on each page (eg by storing the class definition in an include file). If you need to pass information to the constructor, then store that in session variables (or...
Forum: Classic ASP Databases February 23rd, 2004, 09:40 AM
Replies: 2
Views: 4,765
Posted By KenSchaefer
You will need to update each record...

You will need to update each record independantly, especially if you are using Access. The trick is to name each form field differently (but according to a pattern), which then allows you to get the...
Forum: Classic ASP Databases January 31st, 2004, 01:45 AM
Replies: 2
Views: 1,026
Posted By KenSchaefer
I would suggest you post the *exact* error...

I would suggest you post the *exact* error message you are receiving.

However, your code appears to be incorrect. Properties like "cursortype", and "locktype" are properties of the *recordset* not...
Forum: Classic ASP Databases January 28th, 2004, 02:13 AM
Replies: 9
Views: 2,003
Posted By KenSchaefer
There is a far better way of doing this. Put all...

There is a far better way of doing this. Put all the files you don't want downloaded into a single directory. In the IIS MMC Snapin, remove the "read" permission for that folder. IIS will not serve...
Forum: Classic ASP Databases January 28th, 2004, 02:11 AM
Replies: 3
Views: 619
Posted By KenSchaefer
Check here:...

Check here: www.adopenstatic.com/faq/80040e21.asp. Usually caused because you have a field defined of a certain size (eg text(255)), and the user supplies more than this. You need to check this...
Forum: Classic ASP Databases January 28th, 2004, 02:09 AM
Replies: 6
Views: 895
Posted By KenSchaefer
You need to pass the NewsID from one page to the...

You need to pass the NewsID from one page to the next, eg in the first page:

<a href="edit.asp?newsId=1">click to edit item 1</a>

then request.querystring("newsID") will contain the value "1" on...
Forum: Classic ASP Databases January 23rd, 2004, 06:03 AM
Replies: 3
Views: 1,178
Posted By KenSchaefer
If you are using the Jet OLEDB Provider, use %...

If you are using the Jet OLEDB Provider, use % not * as a wildcard, eg:

strSQL = _
"SELECT Field1, Field2, Field3 " & _
"FROM myTable " & _
"WHERE SearchField LIKE '%asad%'"

Cheers
Ken
Forum: Classic ASP Databases January 23rd, 2004, 05:59 AM
Replies: 6
Views: 895
Posted By KenSchaefer
Before: rsNews.Open strSQL, objConn,...

Before:
rsNews.Open strSQL, objConn, adOpenForwardOnly, adLockOptimistic, adCmdText
put the following code:

Response.Write(strSQL)
Response.End

I think it will be pretty obvious what the problem...
Forum: Classic ASP Databases January 23rd, 2004, 05:58 AM
Replies: 5
Views: 5,747
Posted By KenSchaefer
There is nothing wrong with using a parametised...

There is nothing wrong with using a parametised query - you end us with less messy string concatenation in your ASP page. However, if you want to use something other than the default type, you should...
Forum: Classic ASP Databases December 17th, 2003, 02:58 AM
Replies: 6
Views: 958
Posted By KenSchaefer
Can you please post a sample webpage that you are...

Can you please post a sample webpage that you are using?

Cheers
Ken

Microsoft MVP - Windows Server (IIS)
www.adOpenStatic.com
Forum: Classic ASP Databases December 17th, 2003, 02:56 AM
Replies: 9
Views: 4,467
Posted By KenSchaefer
Hi, If Request("filename") is the actual *file*...

Hi,

If Request("filename") is the actual *file* itself, then when you do Server.Mappath(Request("filename")), then you are pasting the entire contents of the file into the Server.Mappath() call. And...
Forum: Classic ASP Databases December 16th, 2003, 01:56 AM
Replies: 9
Views: 4,467
Posted By KenSchaefer
Can you please clarify your last post? Is...

Can you please clarify your last post?

Is Request("filename") the file that the user chooses to upload?
or
Is Request("filename") the name of the file that the user chooses to upload?

The former...
Forum: Classic ASP Databases December 15th, 2003, 04:42 AM
Replies: 6
Views: 958
Posted By KenSchaefer
Firstly, check your NTFS permissions....

Firstly, check your NTFS permissions. IUSR_<machinename> should have change permissions on the folder that the database is in, and all files within that folder.

Secondly, make sure you call...
Forum: ASP Pro Code Clinic December 11th, 2003, 05:58 AM
Replies: 3
Views: 1,630
Posted By KenSchaefer
Rather than concatenating in a loop, you can...

Rather than concatenating in a loop, you can do:

intNumber = 2
strResult = Right("000" & intNumber, 4) ' gives 0002


intNumber = 200
strResult = Right("000" & intNumber, 4) ' gives 0200

Cheers
Forum: ASP Forms December 10th, 2003, 02:00 AM
Replies: 1
Views: 1,287
Posted By KenSchaefer
The problem is not to do with ASP datatypes. When...

The problem is not to do with ASP datatypes. When you use an SQL string, you are sending a literal string of text to the *database engine* for processing, and the SQL string needs to be valid, so...
Forum: Classic ASP Databases December 10th, 2003, 01:57 AM
Replies: 9
Views: 17,824
Posted By KenSchaefer
Hi, Common causes of 80040e10 errors are...

Hi,

Common causes of 80040e10 errors are detailed on my FAQ page:
http://www.adopenstatic.com/faq/80040e10.asp
which Imar has previously posted. Can you please check that the databases on all the...
Forum: Classic ASP Databases December 1st, 2003, 10:38 PM
Replies: 9
Views: 11,632
Posted By KenSchaefer
To repesent a literal single quote mark, you...

To repesent a literal single quote mark, you escape it by prepending another single quote mark:

INSERT INTO myTable (myField) VALUES ('This is text with a quote '' in it')

and the text:

This is...
Showing results 1 to 25 of 111

 


All times are GMT -4. The time now is 01:34 PM.


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