Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
Register
| FAQ | Members List | 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 15 of 15
Search took 0.01 seconds.
Search: Posts Made By: danastasio
Forum: Classic ASP Databases October 1st, 2007, 01:04 PM
Replies: 0
Views: 860
Posted By danastasio
question about forms

My page displays multiple pairs of fields in which a choice in the first field creates a specific list in the second field. The data is returned from a SQL Server 200 database, and the page works...
Forum: Classic ASP Databases February 2nd, 2007, 02:34 PM
Replies: 32
Views: 3,335
Posted By danastasio
Add a space after FROM now: strSQL = "SELECT...

Add a space after FROM
now:
strSQL = "SELECT * FROM" & tablename

change to:
strSQL = "SELECT * FROM " & tablename
Forum: Classic ASP Databases January 31st, 2007, 02:25 PM
Replies: 8
Views: 930
Posted By danastasio
Thanks. I did not know what about DSN...

Thanks. I did not know what about DSN connections, but thanks to your post have learned a bit more today.
Have you tried response.write recTmp("Username") to verify no records are being returned?...
Forum: Classic ASP Databases January 31st, 2007, 10:12 AM
Replies: 8
Views: 930
Posted By danastasio
I'm new, but it seems like you should set...

I'm new, but it seems like you should set "recTmp.Open" = to the database properties/ username / password. And then run your SELECT against recTmp.Execute <SQL Code>.

As an alternative connection...
Forum: Classic ASP Databases January 29th, 2007, 10:44 AM
Replies: 2
Views: 1,060
Posted By danastasio
Thanks for your help. Your observation about the...

Thanks for your help. Your observation about the timing matched my gut feeling. I didn't realize I was mixing client-side and server-side code, so it appears I have more reading to do. Thanks again.
Forum: Classic ASP Databases January 26th, 2007, 04:10 PM
Replies: 2
Views: 1,060
Posted By danastasio
perform multiple things with one button

I'm new to ASP, and have looked online and in books for an answer without success. I have a page that displays 40 columns of data with multiple rows so that users can edit survey data (call this page...
Forum: Classic ASP Databases January 25th, 2007, 03:04 PM
Replies: 3
Views: 973
Posted By danastasio
Not sure if this is the BEST method, but if the...

Not sure if this is the BEST method, but if the table structures are identical you can use:

INSERT INTO database_name.owner.table_name
SELECT * FROM other_database_name.owner.table_name
Forum: Classic ASP Databases January 22nd, 2007, 11:00 PM
Replies: 2
Views: 1,424
Posted By danastasio
I pulled these off the web. I've used the...

I pulled these off the web. I've used the standard one in my code wih success. This might give you a start until a guru can jump in...

Currency:
<% = Format( num, "Currency" ) %><BR>
Fixed:
<%...
Forum: Classic ASP Databases January 21st, 2007, 09:28 AM
Replies: 6
Views: 788
Posted By danastasio
Hi Dink, Try the following: ...

Hi Dink,

Try the following:

code1=request.form("searchCode2")
code2=request.form("searchCode3")

qry = "SELECT * FROM LA_Codes WHERE Code BETWEEN '" & code1 & "' AND '" & code2 & "'"

Be...
Forum: Classic ASP Databases January 17th, 2007, 02:45 PM
Replies: 2
Views: 2,176
Posted By danastasio
Hi Krishna, I'm new, but this is how I use...

Hi Krishna,
I'm new, but this is how I use stored procedures with SQL2K from ASP.
I hope you can get some value from it:

cust_code = Session("Cust_Number")

set...
Forum: Classic ASP Databases January 16th, 2007, 11:13 PM
Replies: 4
Views: 9,771
Posted By danastasio
I'm new, but an approach that seems likely to...

I'm new, but an approach that seems likely to produce the desired result would be to set variables for the individual fields inside the for loop, and then pass the variables in as parameters to your...
Forum: Classic ASP Databases January 16th, 2007, 08:37 PM
Replies: 4
Views: 591
Posted By danastasio
From a SQL perspective, the % sign works as a...

From a SQL perspective, the % sign works as a wild card with the LIKE but shouldn't be used to test whether the username matches exactly. You might consider pushing both sides of the comparison to...
Forum: Classic ASP Databases January 16th, 2007, 12:14 PM
Replies: 2
Views: 1,870
Posted By danastasio
Thanks for your help. I did run into the...

Thanks for your help.
I did run into the problem of the checkbox not returning any value when it was unchecked, so I never entered the Else statement.
I got around it by setting...
Forum: Classic ASP Databases January 10th, 2007, 01:50 PM
Replies: 2
Views: 1,870
Posted By danastasio
update mulitple rows in SQL 2K

Some background: I use a stored procedure to get the data from SQL, and a loop using ASP to display a table with multiple columns in rows based on site number and unit number. The first column of...
Forum: ASP.NET 1.0 and 1.1 Basics January 5th, 2007, 04:01 PM
Replies: 3
Views: 3,133
Posted By danastasio
I'm pretty new to the ASP world, but found that...

I'm pretty new to the ASP world, but found that using
<% response.write FormatNumber(rs("Overall_Rating"),2,-1) %>
will output my data from field "Overall_Rating" using connection 'rs' with the...
Showing results 1 to 15 of 15

 


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


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