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 25 of 308
Search took 0.01 seconds.
Search: Posts Made By: Steven
Forum: SQL Server 2000 October 14th, 2008, 05:14 PM
Replies: 1
Views: 1,260
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,797
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: 866
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: 800
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: 2,077
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,280
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,750
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,995
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,355
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,723
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: 919
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,757
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,682
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: 4,107
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: 911
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,232
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,457
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,720
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,941
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,720
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,367
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,287
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,459
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,383
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,333
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

 




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