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 500
Search took 0.05 seconds.
Search: Posts Made By: Old Pedant
Forum: SQL Server ASP January 15th, 2011, 04:20 PM
Replies: 6
Views: 2,012
Posted By Old Pedant
Yes, but with the caveat that it will be 90 days...

Yes, but with the caveat that it will be 90 days to the second, not to the day, as I discussed back in November.

So, again, you might be better off doing part of the work in ASP code:

SQL =...
Forum: BOOK: Beginning Database Design Solutions ISBN: 978-0-470-38549-4 January 14th, 2011, 10:20 PM
Replies: 3
Views: 6,004
Posted By Old Pedant
The problem with this is that you can't use the...

The problem with this is that you can't use the database's built-in referential integrity.

That is, you can't say
CREATE TABLE foo (
subtypeType INT, -- or use ENUM if the database supports...
Forum: HTML Code Clinic January 13th, 2011, 10:01 PM
Replies: 1
Views: 779
Posted By Old Pedant
names are *NOT* ids. If you want to use...

names are *NOT* ids.

If you want to use document.getElementById() to refer to something, you must give it an ID. The name is of no consequence for getElementById().

So:
<body>
<iframe...
Forum: ASP.NET 2.0 Basics January 13th, 2011, 09:57 PM
Replies: 1
Views: 1,734
Posted By Old Pedant
Short answer: Yes. Longer answer: Yes, but...

Short answer: Yes.

Longer answer: Yes, but there are tons of capabilities added specifically for the support of the ASP.NET environment that are not intrinsically part of the .NET framework.
...
Forum: Javascript January 4th, 2011, 09:08 PM
Replies: 6
Views: 978
Posted By Old Pedant
Of course, the easy alternative is to find a GIF...

Of course, the easy alternative is to find a GIF that *does* animate forever. Keeps cycling over and over. So it won't matter when the image is viewed.
Forum: Javascript January 4th, 2011, 09:06 PM
Replies: 6
Views: 978
Posted By Old Pedant
Oh, you mean the animated gif is not one that...

Oh, you mean the animated gif is not one that animates forever!

So the problem is that when you re-show it, the image isn't really refreshed and the user just sees the image as it was at the end...
Forum: Classic ASP XML January 4th, 2011, 06:35 PM
Replies: 3
Views: 5,384
Posted By Old Pedant
Ummm...your XML isn't at all valid. These...

Ummm...your XML isn't at all valid.

These lines:
act.WriteLine("<photo image="""& rs("pImage") )
act.WriteLine("bigimage=""" & rs("pImage")&"")
act.WriteLine("lightboxinfo=" & rs("pname"))...
Forum: Javascript January 4th, 2011, 06:29 PM
Replies: 6
Views: 978
Posted By Old Pedant
Ummm...whether and how a GIF animates has nothing...

Ummm...whether and how a GIF animates has nothing to do with JavaScript. If your GIF only animates (runs through its cycle of images) once, the GIF is wrong.
Forum: Classic ASP Databases January 3rd, 2011, 05:14 PM
Replies: 3
Views: 1,014
Posted By Old Pedant
In other words, just use SELECT @@IDENTITY ...

In other words, just use SELECT @@IDENTITY

But one caution: Be sure you use the *SAME* connection (and do NOT close and reopen it!) for the INSERT and then the SELECT @@IDENTITY
Forum: Classic ASP Basics December 30th, 2010, 02:24 PM
Replies: 3
Views: 1,794
Posted By Old Pedant
Depending on how complex the filter operations...

Depending on how complex the filter operations you need, you could possibly do this all in JavaScript in the browser.
Forum: Classic ASP Basics December 29th, 2010, 06:53 PM
Replies: 3
Views: 1,794
Posted By Old Pedant
So where is that much data COMING from??? Surely...

So where is that much data COMING from??? Surely it's coming from a database or Excel sheet, already, no? So why not do the filtering at that level, using SQL???

But yeah, you *can* use a...
Forum: JSP Basics December 28th, 2010, 08:12 PM
Replies: 6
Views: 9,228
Posted By Old Pedant
How can we tell without seeing your JSP code???? ...

How can we tell without seeing your JSP code????

It *FEELS* like you are trying to both write out a binary image *and* write out HTML text with the same Response stream, in which case the error...
Forum: BOOK: Beginning ASP.NET 4 : in C# and VB December 28th, 2010, 07:12 PM
Replies: 11
Views: 3,137
Posted By Old Pedant
Sorry, I don't have the time to download and try...

Sorry, I don't have the time to download and try all that. Maybe this weekend if nobody else steps in first.

But I say again: Try using the debugger.
Forum: Classic ASP Basics December 28th, 2010, 06:46 PM
Replies: 3
Views: 1,315
Posted By Old Pedant
Well, dunno why you couldn't do some simple...

Well, dunno why you couldn't do some simple browser detection and then plunk in the code version that matches the browser.

You can do
<%
agent = Request.ServerVariables("HTTP_USER_AGENT")...
Forum: BOOK: Beginning ASP.NET 4 : in C# and VB December 28th, 2010, 06:38 PM
Replies: 11
Views: 3,137
Posted By Old Pedant
Not enough context to even attempt to guess at...

Not enough context to even attempt to guess at it.

What *IS* variable e? Have you debugged to make sure it is what you think it is??? Put a breakpoint on line 20. Check that value of e. Check...
Forum: BOOK: Beginning ASP.NET 4 : in C# and VB December 27th, 2010, 10:32 PM
Replies: 11
Views: 3,137
Posted By Old Pedant
This seems REALLY suspicious: ...

This seems REALLY suspicious:

FileUpload FileUpload1 = (FileUpload)ListView1.InsertItem.FindControl("File Upload1");

Visual Studio doesn't create controls that have spaces in their IDs. ...
Forum: Classic ASP Basics December 27th, 2010, 05:28 PM
Replies: 3
Views: 1,315
Posted By Old Pedant
*** CROSSPOST *** ...

*** CROSSPOST ***
http://www.aspmessageboard.com/showthread.php?t=234298

Please don't crosspost unless you AT LEAST tell people you are doing so. People will end up wasting their time answering...
Forum: SQL Server 2000 December 23rd, 2010, 04:37 PM
Replies: 1
Views: 929
Posted By Old Pedant
Show the full query. Remember, DISTINCT...

Show the full query.

Remember, DISTINCT means "distinct in *ALL* the fields SELECTed".

If *ANY* field in the SELECT is different, then that record can *NOT* be combined with other records and...
Forum: Excel VBA December 23rd, 2010, 04:34 PM
Replies: 2
Views: 1,215
Posted By Old Pedant
Ummm...this has nothing to do with ASP. ...

Ummm...this has nothing to do with ASP.

Maybe a moderator could move it to an Excel or VBA forum?
Forum: SQL Language December 22nd, 2010, 08:02 PM
Replies: 12
Views: 1,511
Posted By Old Pedant
Sorry...can't show them to you. Proprietary. ...

Sorry...can't show them to you. Proprietary. Briefly, they are stored procedures (so in reality maybe 10 different queries in one?) that do statistical analysis of time series data.
Forum: SQL Language December 22nd, 2010, 06:39 PM
Replies: 12
Views: 1,511
Posted By Old Pedant
And before you ask, let's show one more simple...

And before you ask, let's show one more simple variation on that:

SELECT vendorName
FROM Vendors
WHERE vendorID IN (
SELECT O.VendorID
FROM Orders AS O, Customers AS C
...
Forum: SQL Language December 22nd, 2010, 06:24 PM
Replies: 12
Views: 1,511
Posted By Old Pedant
Trivial change to prior query: SELECT...

Trivial change to prior query:
SELECT vendorName
FROM Vendors
WHERE vendorID IN (
SELECT O.VendorID
FROM Orders AS O, Customers AS C
WHERE O.customerID = C.customerID AND...
Forum: SQL Language December 22nd, 2010, 05:12 PM
Replies: 12
Views: 1,511
Posted By Old Pedant
Once you give an alias to a table (e.g, "Orders...

Once you give an alias to a table (e.g, "Orders AS O") you can no longer use the full table name to refer to fields.

So if the code does "Orders AS O" then you need to use "O.VendorID"

For the...
Forum: SQL Language December 22nd, 2010, 03:40 PM
Replies: 12
Views: 1,511
Posted By Old Pedant
CAUTION: None of these queries are going to be...

CAUTION: None of these queries are going to be very efficient unless you have the right indexes in place!! What are "right indexes"? It depends on the DB. MySQL is especially fussy about indexes...
Forum: SQL Language December 22nd, 2010, 03:38 PM
Replies: 12
Views: 1,511
Posted By Old Pedant
That's tougher. Hmmm... SELECT vendorName...

That's tougher. Hmmm...

SELECT vendorName
FROM Vendors
WHERE vendorID IN (
SELECT O.VendorID
FROM Orders AS O, Customers AS C
WHERE O.customerID = C.customerID AND C.State =...
Showing results 1 to 25 of 500

 


All times are GMT -4. The time now is 04:05 PM.


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