Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: monkle
- Order by date
-
Employee scheduling package needed
I have been contacted by a non-profit organization that is having problems with organizing their volunteers to keep their employee schedule filled. I think that their best bet would be a web-based app where employees can hit a link and view slots currently taken, and be able to sign up for... -
Result sets in triggers, stored procedures, and functions
For anybody looking for information, here is a series of articles that have gotten me a good bit further along: http://www.databasejournal.com/features/mysql/article.php/10897_3525581_2 http://www.databasejournal.com/features/mysql/article.php/10897_3547931_2... -
Result sets in triggers, stored procedures, and functions
I am running MySQL 5.0.27 I need to know how to deal with result sets in pure SQL functions/stored procedures. I will explain: I am working on building a set of triggers for a relational database. Essentially, I have two sets of independent tables, and I want to keep them in sync. I have a... -
One to many group_concatinate join
r937: Thank you for your response. After I made the post, I got inspired to try passing the variable in, however I never got the user defined variable to set correctly. After fooling with it for some time I began to question the need for that set of data to be returned in this particular... -
One to many group_concatinate join
I have a 106 line query to draw in data from all over a relational database and dump into a single table for export. I am having issue with one section of the code, where I want to pull multiple rows (the first 5) into a delimited column for each row in the destination table. Here is the SQL... -
sending email via smtp server
Windows 2000 IIS 5 PHP 4.4.2 I am currently working on setting up a webserver which needs to be able to send out emails to users. I am looking for a class that will login to an SMTP server before it tries to send the mail, but the only stuff I can find is for Linux systems. If anyone can... -
logging var dumps in includes
We are having issues with our site, and I have to put some logging into place to track variables. I have been beating my brains out on the issue all morning and every time I think I'm getting somewhere I hit a dead end with the solution, and it fails to take all considerations into account... -
multiple queries VS joins
I am working on a project that utilizes a relational database. So far I have been opting for one larger query with multiple join clauses as opposed to multiple select queries. I had a co-worker raise question over my approach, so I am looking for some outside input. So far I have been unable... -
-
Operand should contain 1 column(s)
Thank you for such a verbose description of the answer "No, I don't know if this is common". I know very well that the most common use of the forums involves inspection of raw code rather than abstract conceptualization. Since a more detailed inspection is desired, I will post the query itself... -
Operand should contain 1 column(s)
I have been working on writing a query all morning, and am into the debug phase. When I try to run the query, the sql server returns: "Operand should contain 1 column(s)". I have looked around, trying to find the flaw in the query and also trying to narrow down where the error might be. I... -
multidimensional array recursive search
The structure varies. I finally found something that helped, which led to the following user-defined function: protected function inArrayR($strVal, $arrHeap){ foreach ($arrHeap as $value) { if ($strVal == $value){ return true; } elseif (is_array($value)) { if... -
multidimensional array recursive search
PHP Version 5.1.2-1.dotdeb.2 I am doing something right now that requires that I check for the existence of a value in a multidimensional array. It doesn't matter at what level in the multidimensional array the value is found, I just need to know if it's anywhere in the array or not. I have... -
Handling user interaction with form
As a solution, is there a way to detach or start a process so that it will continue running regardless of what happens in the browser? If it is possible to do this in such a way that multiple instances of the detached process can run without interfering with each other then it could be a valid... -
Handling user interaction with form
I have a system that is currently live that is having issues with handling user interaction. To be more specific, towards the end of a series of pages displayed to the user I run a series of backend functions, including cURL sessions and database work. It is imperitive that the user not... -
-
telnet through PHP?
Summary: I have to find a way to automate connecting to a remote server (probably through telnet) and sending a series of commands. Detail: We are currently using a remote database server and a local database server. We are going to consolidate everything locally, but to speed the process up... -
Returning distinct based on column value
I'm sorry, I posted an incorrect url to the webpage if you wanted to see where the query was being used. The correct url is http://www.movies4wholesale.com/alphalisting.php?category=4&go=1&ppstart=$0.50&ppend=$0.50- monkle
- Post #6
- Forum: Microsoft SQL Server: Programming
-
Returning distinct based on column value
vongrunt: Thank you very much for your help, I have no idea how much time you saved me. You can see what I was working on by going to http://www.movies4wholesale.com/test/alphalisting.php?category=4&go=1&ppstart=$0.50&ppend=$0.50 . The listing was by sku, and consequently it was returning...- monkle
- Post #5
- Forum: Microsoft SQL Server: Programming
-
Returning distinct based on column value
yes. Using the above example, let's say it's column 4 (It is not the column that I am trying to return distinct on)- monkle
- Post #3
- Forum: Microsoft SQL Server: Programming
