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 31
Search took 0.01 seconds.
Search: Posts Made By: carswelljr
Forum: SQL Language May 7th, 2007, 04:59 PM
Replies: 9
Views: 1,497
Posted By carswelljr
o.k this one query is driving me nuts. i got...

o.k this one query is driving me nuts. i got records to display but not the way i need them to. one of my buddies said that i cannot write this query with 1 statement that it has to be in 2 and loop....
Forum: SQL Language April 30th, 2007, 01:18 PM
Replies: 9
Views: 1,497
Posted By carswelljr
yes, i got the query to return records. i used...

yes, i got the query to return records. i used the solution doug provided me as well, but our dba did not want to use the case statements for some reason??? thank you both for all of your help!!!
Forum: SQL Language April 30th, 2007, 12:41 PM
Replies: 9
Views: 1,497
Posted By carswelljr
thank you for your help, it looks like i am...

thank you for your help, it looks like i am getting closer, that query actually does execute but displays no results. what does the s in s.category, s.issue_count relate to?
Forum: SQL Language April 30th, 2007, 12:14 PM
Replies: 9
Views: 1,497
Posted By carswelljr
I would like to count 5 categories, which will be...

I would like to count 5 categories, which will be based on the group_name that has the most values. (eg group_name1 was chosen 10 times, group_name2 was chosen 3 times all for category1, then the...
Forum: SQL Language April 30th, 2007, 11:49 AM
Replies: 9
Views: 1,497
Posted By carswelljr
new display count query

SELECT v.category, COUNT(v.category) AS issue_count, c.color
FROM TICKET_VIEW v, COLORTBL c
WHERE (c.min_issues > issue_count) AND (c.max_issues <= issue_count)
GROUP BY v.category...
Forum: SQL Language April 19th, 2007, 09:44 AM
Replies: 2
Views: 1,377
Posted By carswelljr
thank you for your very fast help, i will try...

thank you for your very fast help, i will try that right now.
Forum: ASP.NET 2.0 Basics April 19th, 2007, 09:29 AM
Replies: 1
Views: 1,122
Posted By carswelljr
display results

I am trying to count 5 categories, which will be based on the errorcode that has the most values. (eg errorcode1 was chosen 10 times, errocode2 was chosen 3 times all for category1, then the image in...
Forum: SQL Language April 19th, 2007, 09:26 AM
Replies: 2
Views: 1,377
Posted By carswelljr
display count results and image in webpage

I am trying to count 5 categories, which will be based on the errorcode that has the most values. (eg errorcode1 was chosen 10 times, errocode2 was chosen 3 times all for category1, then the image in...
Forum: SQL Language September 28th, 2006, 09:55 AM
Replies: 3
Views: 1,345
Posted By carswelljr
the update statement is giving me an error: ...

the update statement is giving me an error:
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression....
Forum: SQL Language September 28th, 2006, 09:38 AM
Replies: 3
Views: 1,345
Posted By carswelljr
insert and/or update statement

I am having an issue with this SQL Statement i am trying to write. i want to insert the values (Test Facility) from CCID table INTO CCFD table where CCID.id = CCFD.id this is what i have.

UPDATE...
Forum: VB How-To September 14th, 2006, 03:31 PM
Replies: 0
Views: 642
Posted By carswelljr
populating dropdown in visual web develop

Hello,
Does anyone know how to Dynamically populate a 2nd dropdown based on the values of the 1st dropdown, then display the results in the Gridview? I have done the easy part of populating the 1st...
Forum: Visual Web Developer 2005 September 14th, 2006, 03:30 PM
Replies: 1
Views: 1,320
Posted By carswelljr
populating dropdown help

Hello,
Does anyone know how to Dynamically populate a 2nd dropdown based on the values of the 1st dropdown, then display the results in the Gridview? I have done the easy part of populating the 1st...
Forum: ASP.NET 2.0 Basics September 13th, 2006, 03:42 PM
Replies: 1
Views: 2,497
Posted By carswelljr
Visual Web Developer Help

Good afternoon,
I am writing a web application using visual web developer and while trying to create a dynamic dropdown using the SqlDataSource i am getting these errors when i try to correct either...
Forum: VB How-To September 13th, 2006, 03:40 PM
Replies: 2
Views: 2,381
Posted By carswelljr
Yes, I just went to the place in my web where i...

Yes,
I just went to the place in my web where i would like the dropdown menu to be, then added and configured the Data Source. once i went to view it in the browser, those were the errors i received.
Forum: Visual Studio 2005 September 13th, 2006, 03:19 PM
Replies: 0
Views: 2,026
Posted By carswelljr
Help in Visual Web Developer

Good afternoon,
I am writing a web application using visual web developer and while trying to create a dynamic dropdown using the SqlDataSource i am getting these errors when i try to correct either...
Forum: SQL Server 2005 September 13th, 2006, 03:18 PM
Replies: 1
Views: 2,225
Posted By carswelljr
SQL Server 2005 using Visual Web Developer

Good afternoon,
I am writing a web application using visual web developer and while trying to create a dynamic dropdown using the SqlDataSource i am getting these errors when i try to correct either...
Forum: VB How-To September 13th, 2006, 03:16 PM
Replies: 2
Views: 2,381
Posted By carswelljr
visual web developer 2005

Good afternoon,
I am writing a web application using visual web developer and while trying to create a dynamic dropdown using the SqlDataSource i am getting these errors when i try to correct either...
Forum: VB How-To September 6th, 2006, 04:05 PM
Replies: 2
Views: 3,713
Posted By carswelljr
I found why i was getting the error.

I found why i was getting the error.
Forum: Pro Visual Basic 2005 September 6th, 2006, 01:21 PM
Replies: 2
Views: 4,643
Posted By carswelljr
Run time error 429 - ActiveX component can't creat

I keep getting this error "Run time error 429 - ActiveX component can't create" on my program when i try to run it. Right at this line of code:
Set objApp = GetObject(, "Word.Application")

It...
Forum: VB How-To September 6th, 2006, 01:20 PM
Replies: 2
Views: 3,713
Posted By carswelljr
Run time error 429- ActiveX component can't create

I keep getting this error "Run time error 429 - ActiveX component can't create" on my program when i try to run it. Right at this line of code:
Set objApp = GetObject(, "Word.Application")

It...
Forum: VB How-To August 29th, 2006, 10:47 AM
Replies: 2
Views: 1,294
Posted By carswelljr
The program comes to a halt. It browses and finds...

The program comes to a halt. It browses and finds the folder, but thats all. I have the backend code:
Option Compare Database

Sub table_test()
Dim objApp As Word.Application
Dim str As String
...
Forum: VB How-To August 29th, 2006, 09:08 AM
Replies: 2
Views: 1,294
Posted By carswelljr
how to convert word docs to text to database with

I have written a VB script to convert word.docs to text:
Option Compare Database

Private Sub Cancel_Click()
If MsgBox("Are you sure you want to quit?", vbQuestion + vbYesNo, "Quit?") = vbYes...
Forum: SQL Server 2005 August 28th, 2006, 01:05 PM
Replies: 2
Views: 729
Posted By carswelljr
Thank you. You are correct, presently the...

Thank you. You are correct, presently the database i am using is Access 2003, but i am going to migrate to sql server 2005 this week. This should help me out alot
[8D]
Forum: SQL Server 2000 August 25th, 2006, 12:40 PM
Replies: 2
Views: 933
Posted By carswelljr
perfecto!!! thanks for your help [8D]

perfecto!!! thanks for your help
[8D]
Forum: Javascript How-To August 25th, 2006, 10:36 AM
Replies: 1
Views: 4,339
Posted By carswelljr
how do i convert ms word doc to access tables???

I have these forms that contain data that now need to go into an access database. Does anyone know a script file or conversion tool that does this?
thanks in advance
[8D]
Showing results 1 to 25 of 31

 


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


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