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!

Register Log in
  • Congratulations Chriss Miller 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: *

  1. NateUNI

    Problems with Date_Trunc

    Basically all I want to do is get the current time/date to the second, not the persision the is defaulted to current_timestamp. Could I maybe write a date format statement? Thanks!
  2. NateUNI

    Problems with Date_Trunc

    If I take away the ( ' ) I recieve the following error: ERROR: unterminated string CONTEXT: compile of PL/pgSQL function "update_status" near line 3
  3. NateUNI

    Problems with Date_Trunc

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

    Problems with a Trigger Statement

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

    long raw

    Ok, im running a similar statment. I want to append onto a string that is stored in a blob. This is what I currently have DECLARE v_QUERY CHAR; CURSOR c IS SELECT QUERY FROM MESSAGECONFIG where campaignid = 1902 FOR UPDATE; BEGIN FOR i IN c LOOP v_QUERY:=...
  6. NateUNI

    Pulling Records Based on Date Field

    select * from bugtracking where DateValue([Reported Date]) = #01/04/2004#
  7. NateUNI

    Pulling Records Based on Date Field

    No, I'm just running the query in Access, Thanks Nate
  8. NateUNI

    Pulling Records Based on Date Field

    The query, select * from bugtracking works fine, returns 50,000 rows The query, select * from bugtracking where DateValue([Reported Date]) = #01/04/2004# Does not work, I recieved this error: Data type mismatch in criteria expression The Reported Date field is a type Date/Time with General...
  9. NateUNI

    Pulling Records Based on Date Field

    When I run the following: select * from bugtracking where DateValue([Reported Date]) = #01-04-2004# I recieve the following error: Data type mismatch in criteria expression Any suggestions? Thanks!
  10. NateUNI

    Pulling Records Based on Date Field

    Thanks for the replys! However, when I run this query, select * from bugtracking WHERE CDate(format([Reported Date],"mm/dd/yyyy")) = #01/04/2004# I recieve the following error: Data Type Mismatch in Criteria Expression [Reported Date] is a Date/Time field. So when you convert it...
  11. NateUNI

    Pulling Records Based on Date Field

    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!
  12. NateUNI

    Easy Date Question

    I tried this, SELECT DateValue([Reported Date]) AS ReportedDate, BugTracking.[Tracking Number] FROM BugTracking WHERE (((BugTracking.[Reported Date]) = #12/15/2003#)); and it does not bring back any rows, any other ideas, Thanks!!
  13. NateUNI

    Easy Date Question

    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]...
  14. NateUNI

    SelectLimit with ORDER BY not working with Access Database

    ...= 0; if (isset($_GET['pageNum_Recordset1'])) { $pageNum_Recordset1 = $_GET['pageNum_Recordset1']; } $startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1; $MMsort__Recordset1 = 'asc'; if (isset($_GET['ord'])) { $MMsort__Recordset1 = $_GET['ord']; } $MMname__Recordset1 =...
    • NateUNI
    • Thread
    • Replies: 1
    • Forum: PHP
  15. NateUNI

    Optimizing a Query (Removing Sub Select)

    How about if I have fields in the first select that are not in the second select? Thanks!
  16. NateUNI

    Optimizing a Query (Removing Sub Select)

    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!!
  17. NateUNI

    tranfer "paul" into "Paul"

    You could also use the INITCAP funtion if you database supports it
  18. NateUNI

    Passing variables w/ a link tag

    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!!
    • NateUNI
    • Thread
    • Replies: 3
    • Forum: PHP
  19. NateUNI

    array_multisort problem, not sorting correctly

    Thanks, Thats exactly what I needed!
  20. NateUNI

    array_multisort problem, not sorting correctly

    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] =>...
    • NateUNI
    • Thread
    • Replies: 2
    • Forum: PHP

Part and Inventory Search

Back
Top