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 308
Search took 0.02 seconds.
Search: Posts Made By: Steven
Forum: SQL Server 2000 October 14th, 2008, 05:14 PM
Replies: 1
Views: 1,202
Posted By Steven
LOCK_TIMEOUT

I'm having a bit of trouble with locking:
Say I have 2 stored procedures, P1 and P2.
P1 calls P2, and I want the whole thing to abort after a certain length of time, but I'm not having any luck....
Forum: Access ASP January 12th, 2007, 12:36 AM
Replies: 2
Views: 1,662
Posted By Steven
Setting your RecordSource to something like ...

Setting your RecordSource to something like
SELECT [Category] FROM YourTable GROUP BY [Category]
should do the trick, assuming what you're after is just a list of the categories.

I am a loud man...
Forum: Classic ASP Professional January 9th, 2007, 09:43 PM
Replies: 1
Views: 776
Posted By Steven
Any particular reason you have to use CMD, rather...

Any particular reason you have to use CMD, rather than using FSO?
something like (and this is off the top of my head, so there may be errors)
Dim objFSO, srcFile
Set objFSO =...
Forum: Classic ASP Databases January 9th, 2007, 09:34 PM
Replies: 4
Views: 738
Posted By Steven
If by "empty" you mean Null, then you could use: ...

If by "empty" you mean Null, then you could use:
SELECT ... WHERE Complete<>'Yes' OR Complete IS NULL

I am a loud man with a very large hat. This means I am in charge
Forum: Access ASP November 26th, 2006, 06:32 PM
Replies: 1
Views: 1,937
Posted By Steven
have you tried setting the object width to 100%? ...

have you tried setting the object width to 100%?


I am a loud man with a very large hat. This means I am in charge
Forum: Access ASP November 26th, 2006, 06:30 PM
Replies: 1
Views: 7,053
Posted By Steven
try this: strConn =...

try this:
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" &_
"Data source=D:\TimeReportDB\TimeReport.mdb;" &_
"Jet OLEDB:System Database=D:\TimeReportDB\Security.mdw;" & _
"User...
Forum: Access ASP November 26th, 2006, 06:25 PM
Replies: 1
Views: 1,623
Posted By Steven
Regardless of your Web server's locale, a date in...

Regardless of your Web server's locale, a date in Access must always be mm/dd/yyyy
Try this:

vardate=Request.Form("el")
Set rsEL = AdoCon.Execute ("exec qryweqrl #" & Month(vardate) &"/" &...
Forum: Access ASP November 26th, 2006, 06:16 PM
Replies: 1
Views: 1,870
Posted By Steven
Use DateDiff to get the age. eg: DateDiff('yyyy',...

Use DateDiff to get the age. eg: DateDiff('yyyy', BirthDate, Now())
Also - are you clearing out your connections and recordsets?
eg: Rs.Close
Set Rs = Nothing

I am a loud man with a very large...
Forum: Access ASP November 26th, 2006, 06:14 PM
Replies: 1
Views: 1,254
Posted By Steven
If you use the Microsoft Jet interface with an...

If you use the Microsoft Jet interface with an OLE call, rather than ODBC, it should work OK.
-> http://www.connectionstrings.com/?carrier=access

I am a loud man with a very large hat. This means...
Forum: Access ASP November 26th, 2006, 06:09 PM
Replies: 1
Views: 2,578
Posted By Steven
The problem is that ISNULL functions differently...

The problem is that ISNULL functions differently in Access.
In Access, IsNull returns True or False for ONE parameter.
I'd suggest using IIF (check Access Help) with something like:
mstrSql =...
Forum: Classic ASP Databases March 28th, 2006, 12:44 AM
Replies: 1
Views: 860
Posted By Steven
The problem with your syntax is that datediff...

The problem with your syntax is that datediff requires 3 parameters:
The format of difference, and the two dates
such as DateDiff("d", Rs("b"), Rs("c"))
check this out, it should give you the...
Forum: Classic ASP Basics December 4th, 2005, 05:26 PM
Replies: 1
Views: 6,639
Posted By Steven
because the content type is essentially forcing a...

because the content type is essentially forcing a download, having a relative path to your css, such as
<link rel=stylesheet type=text/css href="yourstyle.css">
won't work becuase the Excel file...
Forum: Classic ASP Basics December 4th, 2005, 05:20 PM
Replies: 1
Views: 6,451
Posted By Steven
It doesn't matter really whether or not an IUSR...

It doesn't matter really whether or not an IUSR account was created automatically when you installed IIS. All you have to do is ensure that the anonymous account (which, although usually is the IUSR...
Forum: Classic ASP Basics December 4th, 2005, 05:15 PM
Replies: 2
Views: 3,840
Posted By Steven
are you assuming that a user will have your page...

are you assuming that a user will have your page open continuously for more than 3 minutes (which would probably be unlikely)? If so, you could use a meta refresh:
<META HTTP-EQUIV=Refresh...
Forum: Access November 21st, 2005, 06:25 PM
Replies: 3
Views: 826
Posted By Steven
Try using: ...

Try using:
(DateDiff("m",Date(),DateSerial(Year([RenewDate])+1,Month([RenewDate]),Day([RenewDate])-1)
))
instead. Put the entire expression in the column rather than referencing a separate...
Forum: Classic ASP Databases November 10th, 2005, 05:57 PM
Replies: 1
Views: 1,151
Posted By Steven
Sounds to me like you've got the web server set...

Sounds to me like you've got the web server set to get the credentials from the user.
Assuming your using IIS.....
Set the web server to account to allow anonymous access - i.e. NOT integrated...
Forum: Classic ASP Databases November 10th, 2005, 05:40 PM
Replies: 2
Views: 2,365
Posted By Steven
OK - here's the problem, your bit of code on line...

OK - here's the problem, your bit of code on line 22:
objRS.Filter = objRS("Albums_Name")
is invalid because the .Filter method requires an actual filter, such as
objRs.Filter =...
Forum: Classic ASP Basics November 10th, 2005, 05:26 PM
Replies: 6
Views: 4,612
Posted By Steven
Never heard of this before, and I must say that...

Never heard of this before, and I must say that I'd have to disagree on principle. whether reading or writing to a recordset, it doesn't matter what the order of fields is.


I am a loud man with...
Forum: Ajax October 20th, 2005, 01:24 AM
Replies: 15
Views: 2,806
Posted By Steven
Another good source: ...

Another good source:
http://www.colgate.com/app/Colgate/AU/HouseholdCare/ProductRecommender/HouseholdCleaners/PDPs.cvsp?product=AjaxPowder

I am a loud man with a very large hat. This means I am...
Forum: Classic ASP Basics October 20th, 2005, 01:15 AM
Replies: 6
Views: 4,612
Posted By Steven
I haven't worked with Access in a while - but...

I haven't worked with Access in a while - but possibly if you're using a Text field type (it might even happen on Memo) that new line characters aren't loved by Access -
Maybe try something like...
Forum: Classic ASP Basics October 20th, 2005, 12:52 AM
Replies: 5
Views: 1,255
Posted By Steven
vinod yadav1919, I'll have to disagree with you. ...

vinod yadav1919, I'll have to disagree with you.
QueryStrings can be used!

Arnabghosh,

perhaps this will help:

Dim strSorter
If Not IsEmpty(Request.QueryString("sort")) Then
strSorter =...
Forum: Dreamweaver (all versions) October 5th, 2005, 06:16 PM
Replies: 3
Views: 1,183
Posted By Steven
Yup, this is more an ASP question, and you should...

Yup, this is more an ASP question, and you should probably post your code

I am a loud man with a very large hat. This means I am in charge
Forum: Access VBA October 5th, 2005, 06:14 PM
Replies: 3
Views: 3,321
Posted By Steven
That sounds much more complicated than something...

That sounds much more complicated than something along the lines of:
Open "C:\myFile.txt" For Output as #1
Print #1, "something"
Print #1, "something else"
Close #1

Access help has more info
...
Forum: ASP.NET 1.1 October 5th, 2005, 06:06 PM
Replies: 1
Views: 4,306
Posted By Steven
sMsg = "<table><tr><td>SomeHTML...

sMsg = "<table><tr><td>SomeHTML stuff</td></tr></table>"
Do While Not Rs.EOF
SendEmail Rs("Name"), "your@email", "some Subject", "Dear " & Rs("Name") & sMsg
Rs.MoveNext
Loop

Function...
Forum: Classic ASP Databases October 5th, 2005, 05:57 PM
Replies: 3
Views: 1,248
Posted By Steven
Use Server.MapPath For example StrConnect =...

Use Server.MapPath
For example
StrConnect = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source = " & Server.MapPath("Security.mdb") & ";" & _
"Persist Security Info=True"



I am a loud...
Showing results 1 to 25 of 308

 


All times are GMT -4. The time now is 03:25 AM.


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