Search results for query: *

When I run the following statement, INSERT INTO public."Bug Status" ("Tracking Number", "Assigned Analyst", status, "Changed By", "Updated Date") VALUES (111111111, 'NS', 'Reported', 'NS', DATE_TRUNC('second', 'current_timestamp')); I recieve the following error: ERROR: function...

I want the following trigger to update a related table when ever a record is inserted/updated. I have the following trigger: CREATE TRIGGER update_status AFTER INSERT OR UPDATE ON public."Bug Status" FOR EACH ROW EXECUTE PROCEDURE public.update_status(); Which Calls this function...

I have the following query, select * from bugtracking where Format([Reported Date],"mm-dd-yyyy") = #01-04-2004# however it does not pull any records, even though there are records for those dates (ie, 1/4/2004 12:29:30 AM) What am I doing wrong with this query, Thanks!

Im trying to do a easy query, SELECT BugTracking.[Reported Date] FROM BugTracking WHERE (((BugTracking.[Reported Date]) Like #12/15/2003#)); which returns 0 records, however the Reported Date field in the database is a type date/time so if i do this query: SELECT BugTracking.[Reported Date]...

I am working with a Access Database and when I run the following code, it returns all records, instead of just the first 20. <?php //Connection statement require_once('Connections/STATS.php'); // begin Recordset $maxRows_Recordset1 = 20; $pageNum_Recordset1 = 0; if...

I have the following query: SELECT * FROM Prospect WHERE Prospect.ID_NUMBER NOT IN ( SELECT ID_NUMBER FROM Prospect_EMAIL WHERE CAMPAIGNID=50) This query takes a LONG time to run. Is that a better way to write this query. I am using Oracle if that helps, Thanks!!

I have several (40 variables) that need to be passes when the user clicks on a A HREF tag. Is there a easy way to do this besides appending the variables onto the link? Am i missing something here? Thanks!!

I'm running into the following problem when I try to use the array_multisort fuction. I'm trying to sort by date [1], then report name [0]. If I print out the multi-dimensional array before the array_multisort function, I recieve the following: Array ( [0] => Array ( [0] => change [1] =>...

I have the following code to generate a random number. However if i leave the txtNumberSeed field the same, and run the method multiple times, it brings back the same random number. Any Help, Thanks!!! public void seedRandomGenerator(){ try{ long seedNumber =...

Im running the following statment in perl: perl -MEmail::Find -ne 'Email::Find->new(sub { print shift->address, &quot;\n&quot; })->find(\$_)' test.txt > output.txt And this is the result: Can't find string terminator &quot;'&quot; anywhere before EOF at -e line 1. The test.txt file only has a...

If I have a string like the following: http://www.google.com/Eds/articles.jsp?articleID=54&campaignID=26&edsArticleTitle=Data Security - Better Safe Than Sorry How would i write a replace statment that will replace anything before the article title to be replaced with a blank space. IE. The...

Is there anyway to move messages from one account to another account without forwarding the message. IE. I want it to look like a new message. Is this possible?? Thanks

I was wondering if anyone had written a NCAA Basketball Pool program in php/mysql for free. If so can you please point me in the right direction. Thanks

I have a primary key field (esequence). What I want to do is store a base64 encode in a field (basedecode) of the primary key value. Does anyone know the oracle statment to accomplish this, THANKS!

Does anyone know of a Database Grid Applet that will display, insert, and delete records from a database. I have looked around to no avail, THANKS!

I would like to export all the email addresses that have sent email to one of my groupwise accounts. Is there a easy way to accomplish this? Doesn't really matter what type of file it exports, just would like to have the informaion, THANKS!

I have the following records (small example), EMAIL SUBMIT_DATE EGROUP ----- ----------- ------ 1@hotmail.com 01/24/2003 01:17:45 BUS-NP 2@hotmail.com 01/24/2003 01:17:45 BUS-NP 3@hotmail.com 01/24/2003 01:17:45 BUS-NP 4@hotmail.com 01/24/2003...

I have looked around for documentation of migrating php 3 to 4 of a IIS server ( I know IIS SUCKS :) ) Does anyone have any documentation on this. I checked out php.net, but was not really able to find out the sequence of events to the upgrade. Do i just download 4 and do a clean install...

If I have the following sql statement, but my array index only goes up to 14, how do i check if index 15 is an Uninitialized array index. This is what I have so far, but still gives me the same error: for($n = 0;$n < 17; $n++){ if($newArray[$n] == &quot;&quot;){ $newArray[$n] = 0; }...

I have the following code...