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 Rhinorhino 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: cLFlaVA
  • Content: Threads
  • Order by date
  1. cLFlaVA

    query help - i'm an idiot

    hi people. i am a moron and apparently know nothing about SQL, despite what my employers may think. i have the query below that is returning values that are sometimes 4x more than they should be. i thought i was handling for this by grouping everything. any idea what i'm doing wrong? i know...
  2. cLFlaVA

    Regional Settings?

    hi people... I am using ASP to generate a tabular report displayed in the browser. users could then potentially copy/paste the report into excel. i am having problems with our german users - after copying/pasting, some dates get all messed up. US date format is MM/DD/YYYY, while Germany's is...
  3. cLFlaVA

    QueryString inconsistencies?

    Hi everyone... This seems to be browser/machine specific, so please let me know if I'm barking up the wrong tree. I have a line of code as follows: Response.Redirect( "frmForecast.asp?qryProjectNumber=" & strProjectNumber & "&qryCostType=" & strCostType & "#" & strGoToBudgetEntity ) In all...
  4. cLFlaVA

    Identity Gaps

    Is there a way to set a table up so that, if you have records like this: ID BLAH -------- 1 kaht 2 onpnt 3 gmmastros 4 Vragabond where ID is an identity int, and you then deleted a row: ID BLAH -------- 2 onpnt 3 gmmastros 4 Vragabond and then inserted another, it would take...
  5. cLFlaVA

    Error Handling?

    Hi. Is there a way to determine if the Err object is "enabled" (for lack of a better term)? I am trying to force an error calling a stored prodedure that doesn't exist. I have On Error Resume Next at the top of the page, and this directly after the .Execute call: If Err.Number <> 0 Then...
  6. cLFlaVA

    Linked Server OpenQuery Update Error

    Hi all. I'm having a hard time here. I know this is kludgy, but I'm trying to make it work. I have a DTS package on SQL Server 2000, attempting to update data in an Oracle 9.2 database. I've already had to unwillingly use the Exec statement along with the OpenQuery statement, which I hate...
  7. cLFlaVA

    imagegif() function

    hi all. i'm creating a thumbnail creator, and i have two seperate sections of the code - one for jpegs and one for gifs. after using imagecopyresampled, my last step is using imageJPEG and imageGIF depending on the image type. as you know i'm about to say, this works fine with jpegs but i get...
    • cLFlaVA
    • Thread
    • Replies: 6
    • Forum: PHP
  8. cLFlaVA

    ASP / Excel Problem

    Hi all, I am generating output in Excel using this line in ASP: Response.ContentType = "application/vnd.ms-excel" sometimes, when i run this report, i get the following popup (alert) message: Could not open 'http://......./page.asp' and then another popup (alert) message: Microsoft Office...
  9. cLFlaVA

    1px Difference in IE - Help?

    Hi all, I'm looking for a non-hack way of fixing my 1-pixel difference for some modifications i'm making on my site. the test page is here: http://coryarthus.com/new_home.html and the css is here: http://coryarthus.com/css/new_main.css i am using ie 6 and i see a 1px red line (made red for...
  10. cLFlaVA

    Wish I Could Do Subqueries...

    Hi all. I have a table like this: tag_id tag_name tag_entry_id 1 cory 9999 2 bob 9999 3 tim 9999 4 cara 8888 5 claire 8888 6 cory 8888 7 cara 7777 8 cory 6666 i'm trying to get...
  11. cLFlaVA

    Supressing Unique Index Violation Errors

    Hi all. I have the following query in a php/mysql application: insert tags ( `tag_name`, `tag_entry_id` ) values ( 'cory', 3 ), ( 'bob', 3 ), ( 'tim', 3 ) where the table has a unique index on tag_name and tag_entry_id (combined). i was hoping this would insert three records...
  12. cLFlaVA

    View or SP?

    Hi all, First, I'd like to explain my understanding of Views and SPs (which may or may not be right). lets say we have a view "MyView" that is compiled like this: select <column listing> from table1 join table2 ... <several other joins> It is my understanding that, when writing a...
  13. cLFlaVA

    Stored Procedure - Pass-Through SQL?

    Hi all, I'm creating a stored procedure that will return a number of records to the calling agent - in this case an ASP application. In the ASP page, I have a comma-delimited set of project numbers. I'd like the SP to only return data for those project numbers. Do I need pass-through SQL...
  14. cLFlaVA

    DOM Inconsistencies btw. IE and Firefox

    Hi all, I've been writing this script today just based on questions I've seen here over the past few days. It basically allows you to specify the number of fields to create, using a select box, then either creates or removes fields depending on the number selected. the red line works...
  15. cLFlaVA

    DTS Error Reporting

    Hi all, Here's my scenario: I have a DTS package with 8 separate steps. This DTS package drops and recreates a table, then fills the table with a bunch of data, and eventually updates a table in a linked oracle server with the collected data. We are running this DTS package with a scheduled...
  16. cLFlaVA

    Linked Servers - Query Issue

    Hi People... I have an MS SQL Server database linked to an Oracle database. The oracle database table is set up with two columns: itplan_lookup_id and itplan_project_name (both numeric, a sequence has been created for the _id column). I am trying to run the following query from SQL Server...
  17. cLFlaVA

    oracle error help

    Hi all, kinda new to in-depth oracle code (i'm a sql server guy). what am i missing here? i get this error: encountered the symbol "THEN" when expecting one of the following: :=.(%; -- get approval date if (curRequest.request_type_id = 30134) then select...
  18. cLFlaVA

    anchor hover - computer needs to think about it

    hey peoples. i have set up a temporary page for this question: http://64.92.201.153/sales_agents.asp if you hover over the links on the left, you might see the mouse turn into the hourglass for a split second (only in IE of course, this doesn't happen in FF). this is driving me insane. can...
  19. cLFlaVA

    php_auth_pw cgi problems

    hi all. i have a site with an admin section i created. the admin section used php_auth_pw and php_auth_user to allow myself entry after entering my name and password. i have recently upgraded my hosting plan, however. suddenly, i couldn't get on my admin section. so i emailed support, and...
    • cLFlaVA
    • Thread
    • Replies: 4
    • Forum: PHP
  20. cLFlaVA

    Why Is The Join Messing Things Up?

    Hi people... given the following query: select sp.sub_id as project_id , cd_bu.code_short_descr as bus_unit , cd_pg.code_short_descr as program_group , pr.program_name as program , sp.sub_name as project_name , sum( cfb.cost_amount ) as...

Part and Inventory Search

Back
Top