Search results for query: *

Thanx drlex. Solution worked like a champ. Thanx imex. I did not use your solution as the first fit my requirements better based on the real problem, not the simple one I used in the question. I had not thought of using the union. I will have to file that one away for the next time. Again...

I have a customer and inventory table. I have a need to create a result set that includes 1 row for each item in inventory. If there are 3 items in inventory for a item, it should generate 3 rows. CustomersTable Structure custid name CustomersTable Rows cust01 cust01name cust02...

I have a data entry form which has a batch header and a sub form with the batch detail records. This form has been used for years and has a bunch of code behind each textbox in the textbox_afterupdate methods to calculate values on the forms, get default values from the database... The company...

I have a large XML file containing one table and many records/fields in the following format: <?xml version="1.0" standalone="yes"?> <NewDataSet> <Table> <BD_U_FL>L</BD_U_FL> <BD_PK>7117</BD_PK> <BD_B_DOCU>B2005061000003122 </BD_B_DOCU> <BD_SEQ>01</BD_SEQ>...

Brilliant... I changed the line setting the iframe source to the following and it worked as advertised. I suspected that it was a cache issue and tried a few things in the page_load code to prevent the page from being cached prior to posting without success. ifrReport.Attributes.Add("src"...

I have a page that contains an IFrame which I use to display PDF reports that are stored in a database. The process is to obtain the PDF from the database, write it to a file and then set the IFrame source property to display it. The problem is that it works on the initial image but will not...

I have a database with a number of global functions. I need to change one of them but want to make sure that I can test it in all the places using it. How do I search the entire database (other functions, forms...) for all usages of "UpdateHistoryDetail()". TIA Mark

The twist is that within one @BATID there may be many companies. What you propose would work if contained in a loop, once for each company. I was hoping to perform the update in one statement without having to loop through a cursor. Building on what your solution was I think the following is...

I don't get what you are trying to do with the EXISTS clause. Following is a bit of pseudo code to hopefully illustrate the requirement better. DECLARE @BATID AS CHAR(36) SET @BATID = NEWID() UPDATE Encounter SET EN_BilledBATID = @BATID, EN_BilledDate = GETDATE() Where EN_BilledDate IS...

If the serch term is "Bill Smith" your query cannot work as neither the first name or the last name are going to be LIKE. Your best bet is to split the query form into the three components. Alternately you could do... Where Salutation + FirstName + LastName LIKE <cfqueryparam...

I am looking for a bit of help creating a SQL update statement. The task is to update a first and last activity date in a company table based on bills that are going through a billing cycle. The following code would update the entire company table and is what I used when I created the new...

I am trying to process an SQL 2005 table which has a field defined as varbinary(max). When I just do a "select *" on the source table the field is defined as a type "G" in the temporary cursor. I process this record and try to update this field to an updatable remote view. The remote view I...

Absolutely correct. The test I put together actually has the same user control on the container page twice. The user control has a magnifying glass (lookup) button which is the only user visable portion of the control. Once the button is pressed I present a filtered grid which has a select...

I found the following article which may do the trick. http://aspnet.4guysfromrolla.com/articles/031704-1.aspx I am giving this a try currently... Thanx

That would work except that it would throw away anything else the user entered on the form. I plan to do this for many lookups on the same container form using different controls for each lookup. I was using comboboxes for these fields and in the "SelectedIndexChanged" event I would query the...

Basically yes. The user control has a filtered grid with a select button on each row. When the select button is pressed I get the key value from the grid and store it to a hidden control (for now). The container page needs to then have a routine run that uses this key, re-reads the record...

I have a user control that acts as a lookup button in that when clicked it presents the user with a list of choices from a database query. The user then selects the row they desire. The easy part is I can set a hidden control or public variable to the key of the record they selected. What I...

Thanx Mike and Olaf. I have just overcome the identity issue in a round about way. For anyone reading along I will pass the solution on. I built a temporary table in the version 2 database by doing a "select * into TempTable where 1=2". I then "DROPPED" the identity column and re-added it as...

Mike you mentioned "sharing the connection". How would I grab the handle used by the connection in the database for use in the pass-through? I do not see a DBGETPROP() which will return the handle. What types of "issues" are you referring too? This sounds like a solution worth exploring. I...

Olaf, there is a bunch of code between the scatter and gather which splits fields from the original tables to new ones, initializes new fields and converts values of other fields. I just wanted to show the basic flow for illustration purposes. Mark