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 | 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 54
Search took 0.01 seconds.
Search: Posts Made By: crabjoe
Forum: Classic ASP Professional June 6th, 2013, 01:52 PM
Replies: 1
Views: 750
Posted By crabjoe
How to dispay parts of queried data in different sections of output?

I'm hoping someone can help. Here's my problem.

Lets say I'm building a report where I query SQL for data and display the individual lines and show a sum at the bottom...

Example:


<%
...
Forum: Javascript November 10th, 2008, 06:48 PM
Replies: 4
Views: 1,671
Posted By crabjoe
Thanks!! Worked like a charm!

Thanks!! Worked like a charm!
Forum: Javascript November 10th, 2008, 03:33 PM
Replies: 4
Views: 1,671
Posted By crabjoe
It's not doing anything. When I select Yes or No...

It's not doing anything. When I select Yes or No in the Product field, I need the Product Code drop down to either Enable itself or Disable itself. The way the code is now, it doesn't do a thing,...
Forum: Javascript November 10th, 2008, 02:05 PM
Replies: 4
Views: 1,671
Posted By crabjoe
Using JS to enable/disable??

Need some help because I can't find an answer using google.

I need to be able to enable/disable a select field in a form, but when disabled, I want the value set to null and the drop down grayed...
Forum: Classic ASP Basics June 9th, 2008, 03:42 PM
Replies: 4
Views: 1,034
Posted By crabjoe
Thanks Folks!!

Thanks Folks!!
Forum: Classic ASP Basics June 6th, 2008, 03:17 PM
Replies: 4
Views: 1,034
Posted By crabjoe
Is there a "like" option?

In SQL you can do

where LAST_NAME like 'JOH%'

Is it possible to do something similar in ASP in an IF?

If LAST_NAME like "JOH%" Then

Thanks!
Forum: Java Basics June 5th, 2008, 01:54 PM
Replies: 1
Views: 2,607
Posted By crabjoe
Help - Javascript Auto fill??

I need some help.

I have a form that if an option or input box is selected, I want the other options/input boxes to go to blank (null). The catch is I don't want to lose the options available in...
Forum: Classic ASP Basics May 12th, 2008, 10:15 AM
Replies: 6
Views: 1,033
Posted By crabjoe
Here's what I did to get it to work. ...

Here's what I did to get it to work.

Function pd(n, totalDigits)
if totalDigits > len(n) then
pd = String(totalDigits-len(n),"0") & n
else
pd = n
end if
End Function
Forum: Classic ASP Basics May 12th, 2008, 09:27 AM
Replies: 6
Views: 1,033
Posted By crabjoe
Matt, There's already a field with the...

Matt,

There's already a field with the actual date of the insert. The varchar field for the start of the weeks is for grouping of what was entered during that week.

I still can't figure out...
Forum: Classic ASP Basics May 11th, 2008, 09:12 PM
Replies: 6
Views: 1,033
Posted By crabjoe
Matt, I can't tell you why the field is a...

Matt,

I can't tell you why the field is a varchar field. All I know is that's what I have to work with because the table already exists.

All I need to know is how to get the leading zeros in...
Forum: Classic ASP Basics May 9th, 2008, 03:29 PM
Replies: 6
Views: 1,033
Posted By crabjoe
Date format

I'm in a big if a bind.

I used the below and got what I wanted:

cur_date = date()
start_week = dateadd("d", 1 - weekday(cur_date), cur_date)

So when I do: <%=start_week%> I get 05/04/2008....
Forum: SQL Server 2000 March 27th, 2008, 11:29 AM
Replies: 17
Views: 6,278
Posted By crabjoe
Yes Jeff, THANK YOU for the explanation on WITH...

Yes Jeff, THANK YOU for the explanation on WITH TIES. I'd never seen it before, but now I know I'll be using it!!
Forum: SQL Server 2000 March 26th, 2008, 08:39 AM
Replies: 17
Views: 6,278
Posted By crabjoe
Thanks for all the help folks.. Now I have to...

Thanks for all the help folks.. Now I have to look up "WITH TIES" to get a better understanding of how it works.
Forum: SQL Server 2000 March 25th, 2008, 04:04 PM
Replies: 17
Views: 6,278
Posted By crabjoe
I'm trying to get this based on the Top 3 because...

I'm trying to get this based on the Top 3 because I want the Top by Month.

MONTH NAME SAVINGS
200801 JOHN 500
200801 MIKE 250
200801 JANE 50
200802 JOHN 500
200802 SHANE 400...
Forum: SQL Server 2000 March 25th, 2008, 02:52 PM
Replies: 17
Views: 6,278
Posted By crabjoe
It only give me the Top 10. Here's what I'm...

It only give me the Top 10.

Here's what I'm trying to get, but lets use Top 3

MONTH NAME SAVINGS
200801 JOHN 500
200801 MIKE 250
200801 JANE 50
200802 JOHN 500
200802 ...
Forum: SQL Server 2000 March 25th, 2008, 02:12 PM
Replies: 17
Views: 6,278
Posted By crabjoe
Select .. Top 10 by Month?

Lets say I have a table, named t_savings, with 3 fields (Month, Name, and Saving). And with every month, there's 100 people being tracked.

Now lets say I want the Top 10 Savers by month. Is...
Forum: Classic ASP Basics March 12th, 2008, 04:15 PM
Replies: 3
Views: 1,125
Posted By crabjoe
That's a great explanation and it works! I...

That's a great explanation and it works!

I was originally going to try "and" but I couldn't see the logic behind it. Now with your explanation, it makes sense.

Thanks!!
Forum: Classic ASP Basics March 12th, 2008, 03:08 PM
Replies: 3
Views: 1,125
Posted By crabjoe
"If or" not working

When I do:

<%If x <> "a" then
response.write "HELLO"
End If%>

Or

<%If x <> "b" then
response.write "HELLO"
Forum: SQL Server 2000 March 11th, 2008, 09:58 AM
Replies: 2
Views: 591
Posted By crabjoe
Thanks Jeff, you gave me the exact answer I...

Thanks Jeff, you gave me the exact answer I needed!! I didn't realize the query needed to be named. That's why I couldn't get it to work!!!
Forum: SQL Server 2000 March 10th, 2008, 01:32 PM
Replies: 2
Views: 591
Posted By crabjoe
Query a Query?

I know I can query an open query, but is it possible to query a query?

As an example, in an open query, I can do the below and it gives me a count.

select count(*) from openquery(D2SQL01,'
...
Forum: Classic ASP Basics February 27th, 2008, 12:31 PM
Replies: 3
Views: 1,306
Posted By crabjoe
Matt, I always check google 1st. Believe...

Matt,

I always check google 1st. Believe me, if I didn't you'd see so many posts here, it would make you head spin.

Thanks for the into. Then 2nd listing you posted was exactly what I needed.
Forum: Classic ASP Basics February 26th, 2008, 03:13 PM
Replies: 3
Views: 1,306
Posted By crabjoe
getting the same day of the week.

I'm putting together a form that I have to log on a weekly bases and I have no idea how to do this. I know what I want to do, but I just don't know how.

What I need is some code that give me...
Forum: Classic ASP Basics February 26th, 2008, 03:08 PM
Replies: 7
Views: 2,677
Posted By crabjoe
The reason I had to take the line breaks out was...

The reason I had to take the line breaks out was because when of Javascript.

I have this script that auto fills a form for editing purposes. Well when the Javascript saw the line break, it would...
Forum: Classic ASP Basics February 25th, 2008, 01:12 PM
Replies: 7
Views: 2,677
Posted By crabjoe
I've got good news... I pretty much gave up and...

I've got good news... I pretty much gave up and was going to look at a Javascript option, but I decided to try comment = replace(comment,vbCRLF,"") again and it worked....
Forum: Classic ASP Basics February 25th, 2008, 10:35 AM
Replies: 7
Views: 2,677
Posted By crabjoe
I'm trying to store the comment in SQL without...

I'm trying to store the comment in SQL without the CRLF. The reason this. I have a edit form that pulled the data from SQL, and using Javascript, it autofills the edit form.

The problem happens...
Showing results 1 to 25 of 54

 


All times are GMT -4. The time now is 10:31 PM.


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