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 25
Search took 0.01 seconds.
Search: Posts Made By: hman
Forum: Beginning PHP June 12th, 2008, 04:40 AM
Replies: 1
Views: 1,227
Posted By hman
How to have Sequential numbers in a recordset?

Hi,

I am retrieving a recordset from a simple database table of two fields.

Within the recordset I want to display a sequential number within the html for each row in the recordset, for example...
Forum: MySQL January 11th, 2008, 04:32 PM
Replies: 2
Views: 2,258
Posted By hman
Hi urt, I tried your query changing the...

Hi urt,

I tried your query changing the table name, but it seems to throw an error?
I am running it on MySql 4.1 in MySQLadmin.


#1064 - You have an error in your SQL syntax; check the manual...
Forum: MySQL January 9th, 2008, 01:52 PM
Replies: 2
Views: 2,258
Posted By hman
Selecting emails by domain (TLD) from MySQL table?

Hi,

I have a table with a large number of emails (10000+). I need to extract specific emails based on their domain extension (TLD). For example I want to extract any .uk domains only from the...
Forum: MySQL January 6th, 2007, 09:13 AM
Replies: 0
Views: 1,276
Posted By hman
Problem importing CSV

Hi,

I am a complete newbie to MySQL!

I am trying to import a CSV file using phpMyAdmin.

I have uploaded the CSV file via FTP to the root directory on my external server (GoDaddy).

Then in...
Forum: SQL Language December 20th, 2006, 06:32 AM
Replies: 5
Views: 2,826
Posted By hman
Thanks Rod. I will try what you have suggested.

Thanks Rod. I will try what you have suggested.
Forum: SQL Language December 14th, 2006, 06:12 AM
Replies: 5
Views: 694
Posted By hman
It appears this post got some experts to reply to...

It appears this post got some experts to reply to the unanswered posts I mentioned.

Rod, to confirm, my previous posts were answered satisfactorily, however what I meant when I did this post was...
Forum: SQL Language December 14th, 2006, 06:06 AM
Replies: 5
Views: 2,826
Posted By hman
Thanks Rod, however I need the SUM for "each"...

Thanks Rod, however I need the SUM for "each" ClickThru field, not for all the ClickThru fields combined together. I really don't want to have to write out the query 30+ times for the 30 fields.
...
Forum: SQL Language December 13th, 2006, 08:22 AM
Replies: 5
Views: 694
Posted By hman
Come on guys, there have been 5 posts from...

Come on guys, there have been 5 posts from different users in this SQL forum since 8th December and not a single reply to any of them!

Please help us!
Forum: SQL Language December 12th, 2006, 04:49 PM
Replies: 5
Views: 694
Posted By hman
Anyone here ?

It has been a while since anybody has replied to posts for the last few days ??
Forum: SQL Language December 8th, 2006, 12:54 PM
Replies: 5
Views: 2,826
Posted By hman
Stored Procedure loop ?

Hi,

I have an online ASP application that is using a stored procedure containing many queries. I need to add a loop query to the stored procedure for an additional query.

In my SQL database I...
Forum: Classic ASP Databases April 4th, 2006, 12:37 PM
Replies: 3
Views: 4,742
Posted By hman
Nobody on this forum provided any help :( ...

Nobody on this forum provided any help :(

Anyway a friend managed to help me and solved it.
Forum: Classic ASP Databases April 3rd, 2006, 12:53 PM
Replies: 3
Views: 4,742
Posted By hman
ASP dynamic SQL query with for loop?

Hi,

I am trying to build a dynamic SQL query in asp using a "for loop".
I can get the "for loop" results to display fine in browser using "response.write"
BUT I want to put the "for loop"...
Forum: SQL Server 2000 November 25th, 2005, 11:25 AM
Replies: 3
Views: 852
Posted By hman
Thanks alot Scott. It was my silly mistake,...

Thanks alot Scott.

It was my silly mistake, doh :)
Forum: SQL Server 2000 November 25th, 2005, 07:51 AM
Replies: 3
Views: 852
Posted By hman
Trigger not working - please help

Hi,

The trigger below does not seem to work?

I have 2 tables:
ecastdata
ecastbounces

When the 'ecastdata' table gets updated with certain criteria I want those records to be copyed into...
Forum: SQL Language April 11th, 2005, 06:18 AM
Replies: 2
Views: 2,655
Posted By hman
Thanks Pooja, that worked nicely :)

Thanks Pooja, that worked nicely :)
Forum: SQL Language April 4th, 2005, 05:23 AM
Replies: 2
Views: 1,046
Posted By hman
Help using wildcards in query

Hi,

I have not had any replies to my post: http://p2p.wrox.com/topic.asp?TOPIC_ID=28039

Please could someone help me out[?][?]

Thanks.
Forum: SQL Language March 16th, 2005, 01:14 PM
Replies: 2
Views: 2,655
Posted By hman
Using wildcards in subquery

Hi,

I am wanting to exlude the coulmn |EcastOpSeed1| in my "subquery" using a wildcard.I am extracting results from 2 tables 'ecastdata' and 'ecastops'.

The coulmn |EcastOpSeed1| in 'ecastops'...
Forum: SQL Language March 16th, 2005, 07:06 AM
Replies: 2
Views: 2,311
Posted By hman
That worked great Pooja. Thanks very much...

That worked great Pooja.

Thanks very much for your help :)
Forum: SQL Server 2000 March 15th, 2005, 12:54 PM
Replies: 1
Views: 1,283
Posted By hman
SQL count query not giving correct results

Hi,

I have 2 tables 'ecastdata' and 'ecastops'. I am running a COUNT on the number of records from the 'ecastdata' table with a specific ID from both tables.

I am excluding certain email...
Forum: SQL Language March 15th, 2005, 10:44 AM
Replies: 2
Views: 2,311
Posted By hman
SQL count query not giving correct results

Hi,

I have 2 tables 'ecastdata' and 'ecastops'. I am running a COUNT on the number of records from the 'ecastdata' table with a specific ID from both tables.

I am excluding certain email...
Forum: SQL Server ASP June 21st, 2004, 10:24 AM
Replies: 11
Views: 7,689
Posted By hman
Here is the section of code I am using in my ASP...

Here is the section of code I am using in my ASP page for the query:


headline_str_db = "Provider=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=C:\datafiles\db1.MDB;"

dim f_str_modifdate2...
Forum: SQL Server ASP June 21st, 2004, 09:56 AM
Replies: 11
Views: 7,689
Posted By hman
Hi Vijay, I don't think it has anything do...

Hi Vijay,

I don't think it has anything do with the line number as line 424 is the last line in my code which is just </html>

Here is a break down of my query:

strQuery2="SELECT ArticleID...
Forum: SQL Server ASP June 21st, 2004, 09:30 AM
Replies: 11
Views: 7,689
Posted By hman
Thanks but I still get an error when just...

Thanks but I still get an error when just inserting into one table. I also have another SQL query in my ASP page, which seems to give the error:

'424 , Object requiredObject required '


Here...
Forum: SQL Server ASP June 18th, 2004, 10:02 AM
Replies: 11
Views: 7,689
Posted By hman
Hi Om, I've sent you an email. Ian

Hi Om,

I've sent you an email.

Ian
Forum: SQL Server ASP June 18th, 2004, 06:47 AM
Replies: 11
Views: 7,689
Posted By hman
Object required error ??

Hi,

I am using this query:

strQuery="INSERT INTO Articles, ArtNode (ArtHeadline, ArtBodyText, ArtStartDate, ArtAuthorID, ArtActive, URD) values ('" & _
f_str_headline & "', '" &...
Showing results 1 to 25 of 25

 


All times are GMT -4. The time now is 12:08 PM.


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