Search results for query: *

...THEN shiptype=DROP ELSE shiptype=STOCK. Any ideas how to write this logic in my query? select if(left(company,5)<>left("ship_company",5), 'DROP', if(company='PHYSICIANS SALES', if(Index("ship_company",'SALES')>0,'STOCK','DROP'),'STOCK')) as shiptype, * from invoices_staging_r100

nope that doesn't work.

...(...) (...) (...) (...) (...) (...) (...) (...) (...) (...) (...) (...) (...) (...) (...) (...) (...) (...) however if you just do a select * from tablename it actualy shows the correct data... so the table ins't really filled with (...) it has real data. This is just odd, there is...

I created a macro that basically parses a excel worksheet into separate worksheets per sales rep and also saves each worksheet into a separate file. The problem is that when the highlighted total bar is copied into a new file it changes color from a light grey filled background to a dark blue...

I have unique company name for e.g. company = "NEW YORK MED CTR" from that I would like make a function to encode it into some kind of alpha numeric code that would be the equivalent. I've considered maybe doing some kind of string to hex function, but haven't found much in terms of T-SQL...

I've got a simple trigger which places a timestamp in the lastupdated filed upon insert or update of the record. The trigger works fine, however i've discovered that when doing an import from DTS the trigger won't fire. (I know it's not a bug and it was designed that way.) Whats a simple way to...

brilliant. this should do the trick.

need the code to do this on sql2000 should be simple. here is the table: comment_id integer primary key, user_id not null references users, ip_address varchar(50) not null, modified_date date not null, content varchar (255) I need a really sumer basic trigger where if any of these filed are...

question. I want to create a sales order database using access 2003 with access forms and reports on a shared network drive. I've created many similar type applications before, however this application I intend to have up to 10 users accessing the database simultaneously. I've found that I...

The examples shown are storing the images in a SQL blob which is not really the direction I want to go. I want to recall images and or documents from a .ASP link. for example image would be shown as <img src="http://www.myserver.com/showimage.asp?id=200"> and for documents I would show this...

Not quite what I was looking for. Here is an example in Perl. <IMG src="http://ogc.navy.mil/ogcwww-cgi/infocon.cgi"> which will show an image on a web page. I want to do a similar sort of thing in ASP.

Problem: I want to be able to display an image on a web page that is pointed to a ASP script. For example. <img src="http://www.myserver.com/firstimage.asp"> firstimage.asp This file should recall a URL from the database that points to an image. I've seen this done in PERL and I assume it...

When I open my access database mdb i get a Security Warning message opening C:\db.mdb This file may not be safe if it contains code that was intended to harm your computer. Do you want to open the file or cancel the operation. This error message is annoying and the file i am using is perfectly...

I've seen it done before. Is there some setting in access where I can set it so when I open up a certain MDB file on my desktop I would just automatically open up my switchboard form?

On a subform I am getting this annoying error message "The LinkMasterFields property setting has produced this error: 'The object doesn't contain the Automation object 'tblMember'. Everything still works and is linked properly, any ideas how to fix that type of error or atleast suppress it?

I have a form that has just a set of buttons on that each of which will launch a report or form. There is no data on this form. Is there a way to turn off the control on the bottom that shows Record 1 of 1. Also there is a Verticle bar on the left side with a triangle. You can click it but it...

Finally found a solution very closely based on your query thanks again!!!

Outstanding! This solution works perfect in Access. Thanks man!

same syntax error. In my query ROW_A, NAME_a, GRADE_A that part works. seems like it craps out on the join. is there someway I could split that query. that the first 4 records for the left side then the last 4 for the right side and join them with a 3rd query.

Here is my point: TABLE2 FNAME LNAME GRADE ----- ----- ----- JOE AMES C JEFF FRANKSON B BILL BARTSON A TIM CARRY A JOHN DOE B JANE ZIMMER C HERE EXPECTED OUTPUT: ROW_A NAME_A GRADE_A ROW_B NAME_B GRADE_B ----- ------...