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 215
Search took 0.04 seconds.
Search: Posts Made By: David Cameron
Forum: Forum and Wrox.com Feedback August 12th, 2003, 07:52 PM
Replies: 2
Views: 794
Posted By David Cameron
No. http://p2p.wrox.com/topic.asp?TOPIC_ID=30 htt...

No.

http://p2p.wrox.com/topic.asp?TOPIC_ID=30
http://p2p.wrox.com/topic.asp?TOPIC_ID=700

regards
David Cameron
Forum: SQL Server 2000 August 12th, 2003, 01:59 AM
Replies: 1
Views: 771
Posted By David Cameron
Cursor *shudder*

For the first time I have been forced to use a cursor in something other than administration scripts. I'm just wondering of there is any other way to solve the problem. It will take a bit of...
Forum: SQL Server 2000 August 11th, 2003, 07:27 PM
Replies: 8
Views: 3,009
Posted By David Cameron
You are trying to alter the name of a file to...

You are trying to alter the name of a file to that of an existing file.

regards
2 days
David Cameron
Forum: SQL Server 2000 August 7th, 2003, 10:22 PM
Replies: 1
Views: 2,289
Posted By David Cameron
WHERE assignedDate BETWEEN @startDate AND...

WHERE assignedDate BETWEEN @startDate AND @endDate
AND ( returnedDate IS NULL
OR
(returnedDate IS NOT NULL AND returnedDate NOT BETWEEN @StartDate AND @endDate)
)


regards
David Cameron
Forum: Classic ASP Professional August 7th, 2003, 10:19 PM
Replies: 9
Views: 9,796
Posted By David Cameron
I'm out of ideas, sorry. regards David Cameron

I'm out of ideas, sorry.

regards
David Cameron
Forum: Forum and Wrox.com Feedback August 7th, 2003, 10:13 PM
Replies: 6
Views: 2,003
Posted By David Cameron
I'm not entirely sure that is a fair...

I'm not entirely sure that is a fair comment.

I've been thinking about your last comment on the the email system for some time. I think we are talking at cross purposes. Consider my perspective. I...
Forum: SQL Server 2000 August 7th, 2003, 07:35 PM
Replies: 2
Views: 1,317
Posted By David Cameron
See: http://www.adopenstatic.com/experiments/recor...

See:
http://www.adopenstatic.com/experiments/recordsetpaging.asp

Under "The adOpenForwardOnly/#Temp Table Method" there an example of paging using a recordset.

regards
David Cameron
Forum: SQL Server ASP August 6th, 2003, 07:52 PM
Replies: 2
Views: 1,746
Posted By David Cameron
A recordset is made up of columns. That means you...

A recordset is made up of columns. That means you can't get a single value for the whole recordset, it will return that value for each row of the recordset.

Use an output parameter to a stored...
Forum: Classic ASP Professional August 6th, 2003, 07:42 PM
Replies: 9
Views: 9,796
Posted By David Cameron
Have you installed the latest version of...

Have you installed the latest version of MDAC?

regards
David Cameron
Forum: SQL Server 2000 August 6th, 2003, 07:39 PM
Replies: 8
Views: 10,494
Posted By David Cameron
I've already said to use ANSI date format. If you...

I've already said to use ANSI date format. If you use dd/mm/yyyy it will read this in as mm/dd/yyyy. This could result in a conversion error if the day is higher than 12.

I'll say it again. Use ANSI...
Forum: SQL Server 2000 August 6th, 2003, 02:59 AM
Replies: 8
Views: 10,494
Posted By David Cameron
Use dd/mm/yy when you display dates to users, but...

Use dd/mm/yy when you display dates to users, but convert this to yyyy-mm-dd when you have to do any work with the database. Use a string formatting function to convert from dd/mm/yy to a database...
Forum: SQL Server 2000 August 6th, 2003, 01:54 AM
Replies: 8
Views: 10,494
Posted By David Cameron
Look into CONVERT, see SQL books online for...

Look into CONVERT, see SQL books online for details. The way the database stores dates has no relation to how they are displayed. You can use convert to change the format to something that suits you...
Forum: SQL Server 2000 August 5th, 2003, 09:45 PM
Replies: 3
Views: 1,252
Posted By David Cameron
You've confused me. I have to admit I don't...

You've confused me. I have to admit I don't understand your table structure. When I posted my reply as far as I could tell it would do exactly what your earlier query did, except that it did it...
Forum: SQL Server 2000 August 5th, 2003, 09:02 PM
Replies: 8
Views: 10,494
Posted By David Cameron
Use Ansi dates (yyyy-mm-dd) and deal with the...

Use Ansi dates (yyyy-mm-dd) and deal with the fact that it is annoying. There are issues when trying to use real international dates with databases etc. Basically you can't totally fix the problems,...
Forum: SQL Server 2000 August 5th, 2003, 07:44 PM
Replies: 2
Views: 1,103
Posted By David Cameron
Why are you using a cursor? Chances are you can...

Why are you using a cursor? Chances are you can do what you want without the cursor.

regards
David Cameron
Forum: Classic ASP Professional August 5th, 2003, 07:43 PM
Replies: 9
Views: 9,796
Posted By David Cameron
Has you DSN been defined in 2003? What is the...

Has you DSN been defined in 2003? What is the text of the error message?

regards
David Cameron
Forum: C# August 5th, 2003, 07:37 PM
Replies: 11
Views: 3,074
Posted By David Cameron
I don't write C#. If I did I'd also subscribe to...

I don't write C#. If I did I'd also subscribe to the C# forum and I'd be asking questions or suggesting answers.

regards
David Cameron
Forum: SQL Server ASP August 4th, 2003, 07:35 PM
Replies: 1
Views: 1,352
Posted By David Cameron
1. Don't do it. Storing BLOBs (Binary Large...

1. Don't do it. Storing BLOBs (Binary Large OBjects) bloats the database for no appreciable gain. Store the path in the database

2. Certainly. If you had your own exchange server you could script...
Forum: SQL Server ASP August 4th, 2003, 07:33 PM
Replies: 1
Views: 2,277
Posted By David Cameron
You could use output parameters to a proc....

You could use output parameters to a proc. eg


CREATE PROCEDURE MyProc
@Sum1 Int OUTPUT, @Sum2 Int OUTPUT, @Sum3 Int OUTPUT
AS

SET NOCOUNT ON

SELECT @Sum1 = SUM(Price1), @Sum2 = SUM(Price2), @Sum3...
Forum: SQL Server 2000 August 4th, 2003, 07:29 PM
Replies: 2
Views: 5,327
Posted By David Cameron
Do you want to convert the varchar to an integer,...

Do you want to convert the varchar to an integer, or do you want to generate a new identity? Do you want the resulting column of be of datatype Identity?

regards
David Cameron
Forum: SQL Server 2000 August 4th, 2003, 07:23 PM
Replies: 1
Views: 696
Posted By David Cameron
I'd avoid doing this. Not for performance...

I'd avoid doing this. Not for performance reasons, but because it makes for a poor database design. Each table/database entity should be created for one purpose. To blend together two tables blurs...
Forum: SQL Server ASP August 4th, 2003, 07:17 PM
Replies: 15
Views: 2,472
Posted By David Cameron
Just to confirm, you ran it with exactly the same...

Just to confirm, you ran it with exactly the same site_id and the results were different? If so, I'm out of ideas. I can only suggest that there is something simple that you might have...
Forum: SQL Server 2000 August 3rd, 2003, 07:38 PM
Replies: 8
Views: 3,009
Posted By David Cameron
Go to the machine where the file is saved. Log...

Go to the machine where the file is saved. Log into the machine. Open up windows explorer. Browse to where the file is stored. Double click on the file.

regards
David Cameron
Forum: SQL Server ASP August 3rd, 2003, 07:36 PM
Replies: 15
Views: 2,472
Posted By David Cameron
You missed the signifigant point in what I said....

You missed the signifigant point in what I said. You need to execute your SQL Statement/proc in query analyser to see what kind of result you are getting. Find out the value of site_id...
Forum: SQL Server 2000 August 2nd, 2003, 05:08 AM
Replies: 1
Views: 950
Posted By David Cameron
Create a default constraint on the column and set...

Create a default constraint on the column and set it to 1. This is realively easy to do using Enterprise Manager.

regards
David Cameron
Showing results 1 to 25 of 215

 


All times are GMT -4. The time now is 02:35 PM.


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