Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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