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 25 of 30
Search took 0.01 seconds.
Search: Posts Made By: 12th_Man
Forum: SQL Language June 22nd, 2004, 11:42 AM
Replies: 0
Views: 653
Posted By 12th_Man
Non-Tree DAGs

I know that there has been some discussion of representing and traversing hierarchies with SQL on this board, but I was hoping to get some advice on a somewhat different problem.

I am building a...
Forum: SQL Language June 17th, 2004, 07:49 AM
Replies: 4
Views: 1,267
Posted By 12th_Man
Thanks Jeff, that's an excellent solution, just...

Thanks Jeff, that's an excellent solution, just what I'm looking for.
Forum: SQL Language June 16th, 2004, 04:29 PM
Replies: 4
Views: 1,267
Posted By 12th_Man
Ignoring nulls in stored proc

I need to write a stored procedure in Sybase that will return a simple result set from one table based on a few criteria passed as parameters to the procedure. Basically the sp has a parameter for...
Forum: VB How-To June 8th, 2004, 10:50 PM
Replies: 3
Views: 8,184
Posted By 12th_Man
Programmatically close a message box

Hello -

I need to be able to automatically click the OK button everytime a certian message box shows up in a given windows application.

I've been reading a few articles about using the Windows...
Forum: Oracle August 12th, 2003, 11:13 AM
Replies: 1
Views: 1,275
Posted By 12th_Man
Parsing values out of a field

Hello -

I am trying to create some reports from an Oracle Database. Unfortunately the database is not normalized (not even 1st normal form) which makes what I am trying to do very difficult.
...
Forum: SQL Language July 25th, 2003, 09:03 AM
Replies: 7
Views: 4,616
Posted By 12th_Man
Thank you pgtips. I was trying to think of a way...

Thank you pgtips. I was trying to think of a way to replace all non space characters and then get the len of the remaining spaces, but yours is much easier.

The only problem I can see is that...
Forum: SQL Language July 25th, 2003, 08:26 AM
Replies: 7
Views: 4,616
Posted By 12th_Man
Ok, thanks for the input. I would prefer to do...

Ok, thanks for the input. I would prefer to do it in SQL, but I think you are right. I'll do it on the client.

Thanks again for the advice.
Forum: SQL Language July 25th, 2003, 08:01 AM
Replies: 7
Views: 4,616
Posted By 12th_Man
Word Count

Quick question:

If I have a table with one of the columns being the text of a message, what is the easiest way to do a query that returns a couple fields out of the table and the number of words...
Forum: SQL Language July 23rd, 2003, 08:16 AM
Replies: 4
Views: 1,303
Posted By 12th_Man
I usually use the <table1> INNER JOIN <table2> ON...

I usually use the <table1> INNER JOIN <table2> ON <criteria> syntax, but recently I had to do some work on an Oracle DB (I used to use only MSSQL) and that syntax didn't seem to work. Have most...
Forum: SQL Language July 23rd, 2003, 07:59 AM
Replies: 4
Views: 1,303
Posted By 12th_Man
SELECT REPORT.id FROM REPORT WHERE REPORT.id...

SELECT REPORT.id
FROM REPORT
WHERE REPORT.id NOT IN
(SELECT REPORT.id
FROM REPORT, KEYWORD
WHERE KEYWORD.report_id = REPORT.id
AND KEYWORD.id IN (1707, 13, 15))

The sub query in the WHERE...
Forum: Classic ASP Databases July 18th, 2003, 10:09 AM
Replies: 2
Views: 1,709
Posted By 12th_Man
The problem is VB and Java define functions...

The problem is VB and Java define functions differently.

1) Java encloses the body of the function in curly braces while VB uses an End Function keyword.
2) Java uses the return keyword while VB...
Forum: Classic ASP Databases July 18th, 2003, 08:38 AM
Replies: 2
Views: 1,709
Posted By 12th_Man
Connection String with VB and Java

I have a site with several ASP enabled pages that all access the same SQL Server database. Some of the scripts are writen in JavaScript others are writtend with VBScript.

When the site used all...
Forum: SQL Language July 17th, 2003, 08:13 AM
Replies: 3
Views: 2,887
Posted By 12th_Man
I'm not sure if you're trying to just run a query...

I'm not sure if you're trying to just run a query that returns a result set with city and state together or if you are actually trying to update your table with the merged column.

If the latter is...
Forum: SQL Language July 15th, 2003, 08:29 AM
Replies: 4
Views: 11,916
Posted By 12th_Man
Aggregate Concatenation

I would really love to know how I could group several rows together and display a comma delimited list of values from one column in a cell.

For example lets say there is a table books with columns...
Forum: HTML Code Clinic July 15th, 2003, 08:10 AM
Replies: 4
Views: 2,039
Posted By 12th_Man
That was it. I'm so used to C and Java code that...

That was it. I'm so used to C and Java code that I didn't even think about the different comment syntax.

Thanks a million.

-Mike
Forum: HTML Code Clinic July 14th, 2003, 03:47 PM
Replies: 4
Views: 2,039
Posted By 12th_Man
I tried using that code but the text ends up...

I tried using that code but the text ends up showing up next to the image, not on top of it. I've tried changing the absolute and relative values in each class but all that does is change the text...
Forum: HTML Code Clinic July 14th, 2003, 11:52 AM
Replies: 4
Views: 2,039
Posted By 12th_Man
Overlay Text on graphic

Hello -

I'm trying to display graphical headers above each section of my page. These headers are basically just a rectangular graphic with a space for text in them. As of now I'm using a graphic...
Forum: HTML Code Clinic July 10th, 2003, 10:47 AM
Replies: 1
Views: 4,467
Posted By 12th_Man
Fixed height cells in tables

Hello all-

I'm having a problem getting a table on one of my pages to come out right and I think I've found the simplest instance of my problem.

The code below is a simple table with 3 cells, 2...
Forum: SQL Language July 3rd, 2003, 02:30 PM
Replies: 3
Views: 2,619
Posted By 12th_Man
By the way this won't work on non SQL Server...

By the way this won't work on non SQL Server DBMS's. I'm not very familiar with other databases but there's bound to be a similar function. If not there should at least be a function to extract the...
Forum: SQL Language July 3rd, 2003, 02:25 PM
Replies: 3
Views: 2,619
Posted By 12th_Man
CONVERT(char(10), GETDATE(), 103) this will...

CONVERT(char(10), GETDATE(), 103)

this will give you a charater string of length 10 in the format you requested. See "Cast and Convert" in the SQL Server 2000 Books On-line. You can use convert...
Forum: SQL Language July 1st, 2003, 12:15 PM
Replies: 5
Views: 2,775
Posted By 12th_Man
At first I though it was because there might be...

At first I though it was because there might be nulls in the field you're counting. But this is not the case because your where clause should filter any rows with nulls in that field. You could try...
Forum: SQL Server 2000 June 26th, 2003, 08:17 AM
Replies: 7
Views: 1,612
Posted By 12th_Man
The order in which you specify the ON portion of...

The order in which you specify the ON portion of the join clause does not matter, i.e. "INNER JOIN Branch b ON s.BranchPk = b. BranchPk" is the same as "INNER JOIN Branch b ON b.BranchPk = s.BranchPk...
Forum: Oracle June 25th, 2003, 11:45 AM
Replies: 2
Views: 7,285
Posted By 12th_Man
LEFT JOIN syntax

Hello-

I'm used to using MSSQL, but I'm now working on an Oracle system. I need to use a Left outter join for a query I'm writting, but I am getting a syntax error that I don't know how to fix. ...
Forum: SQL Language June 23rd, 2003, 12:15 PM
Replies: 6
Views: 15,466
Posted By 12th_Man
I doubt this is exactly what your looking for,...

I doubt this is exactly what your looking for, and it's ver inefficient, but it might help.

First of all you need some unique field in your table that enumerates every row. For this code that...
Forum: SQL Language June 20th, 2003, 05:09 PM
Replies: 3
Views: 1,179
Posted By 12th_Man
Thanks Jeff. Another guy gave me this...

Thanks Jeff.

Another guy gave me this solution:

SELECT City, Difference
FROM
((SELECT testTable.City, testTable.Distance, MIN(testTable.Distance - table2.Distance) AS Difference
FROM...
Showing results 1 to 25 of 30

 


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


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