Recent content by MdotButler

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