Search results for query: *

I have a table that I resides in my live DB but not in my test DB. I can't figure out what the sql syntax would be to copy the table from the one instance to the other. MS Sql looks like it would be something like this insert into ol_rentontrain.atb.ren_custom_tran select *...

I'm trying to create rolling weekly onhand numbers. I've gotten week 1 figured out but am now trying to figure out how to calculate the inventory position for week 2 by adding data to week 1. I have 2 tables being pulled used: PYactuals which has the weekly data BOM which has the beg year...

I'm creating some data to export to a flat text file interface. I've been asked to do either remove the single quotes that reside in the description field OR add double qoutes around the output. select 1 as Division, substring (ca_id from 1 for 1) as dept, (ca_desc) from category where...

I've created a script that unloads a file as a comma-delimited txt file (orderfile.txt). The gotcha is that after the last record there is a comma that I need to remove. IE The comma at the end of the line as shown below. 9,002,7,095,92.0,2318.08,1025.45, 11,899,6,075,0.0,0.0,0.0...

I have a query that works except I need to do a date evalution that takes any document that falls before the current period & puts it into the current period. I'm stumped as to how add this case statement case when P.po_promise < today then today else P.po_promise end to the where clause...

I'm sure I'm missing the obvious reading through faq 701-4230 & the numerous other date posts here but for the life of me my brain isn't getting it. I have a table where all 52 weeks of the year are accounted for Sun-Sat for expample. In the table there is a record for week 4 which is defined...

I've seen thread181-183305 & read it trying to understand how I can remove both a & and a ; from a field. I'm trying to remove the html code in a web link that I'm creating in my query. What I have thus far is url: "http://www.mysite.com/" & Replace([short_description],"&","") & "-p" &...

I made this post in Forum608 & some folks there thought maybe this forum could help me more. Userdata persistance does not seem to be the issue. I see on the MS IE FAQ site that they (MS) tells folks to download a patch to allow IE7 to act as IE6 for sites they're having problems viewing BUT...

Our website runs fine in all browsers BUT IE7. IE7 displays all the text yet does not show any of our site images. We're scratching our heads as to what would be causing this occurance. I'm hoping to find a work around or solution such that our customers are downloading IE7 at a pretty quick...

So it seems that informix won't let me substr or substring a TEXT field....Anyone know how I can convert a TEXT field into a Nvarchar or something else that I can then put into a distinct sql query? - gina

I have a query that starts with a distinct call but I need to pull a text field into the results. However I get an error indicating that I can't use a 'blob' statement with distinct. Here's the primary code: select distinct order_shipments.order_id, order_shipments.shipment_id...

I would think there's a way to do this but for the life of me can't stumble upon the correct syntax. Am trying to select records where the beginning part of the record is held in another field - UPC code data. I'm only concerned with pulling the record if the first 6 digits of the code resides...

Forgive me on the lack of detailed information but I can get more if needed. We are trying to setup a backup dialing process for when our internet connection (T1)/VPN is not responding. We've gotten it to work in 2 locations yet in the 3rd location with same code we get a the following error...

I have a statement that reads select inv_id, initcap(short_description), from ecat_items Which give the short description the first letter capitalization which I want the problem I'm running into is descriptions with apostrophes within them. children's boots gets displayed as Children'S Boots...

I'm creating a view that uses a field that is in a DATE layout, yet the date field I'm interfacing this data to is in a DATETIME layout. I can't find anything that explains how to convert a field from a DATE layout to a DATETIME layout. Any help is appreciated. Thanks Gina

I've created a view that is behaving oddly when I try to query it for other uses in dbaccess yet it behaves correctly if I'm using Access, Crystal or some other ODBC connection. The view name is ren_products & if I do a select * from ren_products where sku=55154 Dbaccess returns all records...

Sorry for the 'neophyte' question but I'm trying to figure out how/where one gets a Informix Client Software Development Kit (Client SDK) with ODBC driver for Windows 32 bit We've been using the downloadable test version for some development & it works find & dandy But knowing how informix...

I've created a email mail merge document (Office XP) to send out as a follow up to some of our customers. However the hypertext link that works fine if I cut & paste the document into unique emails vs mail merging no longer appears as a link. It appears as basic text. Anyone figure out how to...

I've created a email mail merge document to send out as a follow up to some of our customers. However the hypertext link that works fine if I cut & paste the document into unique emails vs mail merging no longer appears as a link. It appears as basic text. Anyone figure out how to work around...

I'm pulling a data list out from an ODBC connection that I want to limit to records created in the last 30 days. In Access the formula would be something like >date()-30. However in MS Query that errors out. Tried >today()-30 in the criteria field & that too fails. The field date format is...