Search results for query: *

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

I am trying to generate an SQL query that returns a DISTINCT row from a single table based on certain column values. For example: Table test: col1 col2 col3 a b c row 1 a b c row 2 a b d row 3 w x y row 4 k b m row 5 I need to be...

I have been trying to familiarize myself with VB.Net 2003, and I've come up with a question about the textbox control that I haven't seen addressed anyplace. When a user is typing in a textbox, and they press the enter key, I want to be able to run a chunk of code. I'm familiar with handling...

I am trying to export from an mssql server into a csv file. The problem is that the data in the database is not "clean". When I do the export, it throws the columns and rows off. I have the following code trying to clean it, and it helps a lot, but I'm still having issues: $arrRemoveChars =...

Our transaction log became too full, to the point that our database could not be accessed. One of my co-workers decided to deal with the problem by manually deleting the transaction log off the server. Is there any way we can repair the functionality of the database without losing the data in...

I've started working on some PHP CLI script utilities recently, and I've run into an issue. Script: <?php $connection = mssql_connect('server', 'user', 'pw'); ?> Error: Call to undefined function: mssql_connect() Is it possible to do this in CLI? I've looked through documentation, and...

I have been working for a little while on writing a php mail script. I have the sending part down pat, but I'm having a hard time finding resources about how to check your email using php. Is it even possible? If anyone could give me a lead on what to look for/where to look, I'd greatly...

I am trying to write a stored procedure to be called from a utility application on a dedicated server. I know that the create view statement alone is correct, but when placed in the context of a stored procedure, I get a syntax error. I do pretty much the same thing with a set of tables, and...

I have a script that updates a database with the contents of a csv file. There are 127,618 rows in the file, but it stops running at around row 4,000. I was wondering if it could be the process timing out, so I added this line to the beginning of the script: set_time_limit(2160000); I have...

I am working on a mail client that uses vb sendmail. All of my mail is being returned to me, with the following error message. With SendMail .SMTPHostValidation = VALIDATE_HOST_DNS .EmailAddressValidation = VALIDATE_SYNTAX .SMTPHost = Server...

Greetings, I am the webmaster/developer for a commercial website. In hopes of studying traffic on the site and making improvements that will drive more sales, I want to install traffic tracking software on the web server, so that I can see if/where we are losing potential customers, as well...