Search results for query: *

All, I have been using the new cfwindow feature, and I love it. But now I'm using it within error trapping, and bubbled exceptions are causing the multiple creation of my support submission cfwindow. I get an error that the cfwindow already exists. I have tried a million ways to keep that from...

Ok, we have a small collection of databases that are similar. Many tables need unique id values, but these id values must come from a pool in one central database. So no IDENTITY columns can be used. I have created a Sequence_Tbl in my central database, but now when I want to copy data from one...

This is a very weird problem... I am trying to use the datefield with the included calendar control and when I have several calendar controls on a page and I click the calendar icon, the resulting calendar div is placed behind the other calendar controls. So you can't see the entire month, the...

Hello all. I am using a third-party solution to generate word documents on our server. For control purposes, I am also adding two document variables to the document. Now I am writing VBA that will be included with all the word documents our clients use. I want to "check" to see if the variables...

Hello all, I have a need to retrieve data from a table that currently stores data as iterative rows (e.g., column1, column2, etc.) I need to retrieve that as a generic set of columns with the repeated column data as rows. Thanks

All, First, I know that it is best to store the photos in a folder, and just store the path to the image in the database. That is what I currently do for all my implementations of this sort of task. But. We have been tasked with creating a sql server report of a photo directory. I am getting...

I have a view: CREATE VIEW table_view AS SELECT USERID, LEOTYP, LEONUM, LEOST, ACTIVE_FLAG , CAST(LEOEXM + '/' + LEOEXD + '/' + LEOEXY AS DATETIME) AS EXPIRES FROM table WHERE ISDATE(LEOEXM + '/' + LEOEXD + '/' + LEOEXY) = 1 GO That only gets items that have a valid date. Querying the...

I'm experimenting with it, so I can start comparing. But unfortunately I'm getting an error. So if anyone has any ideas with this I appreciate any input. Code following (in C#) using System; using System.Collections; using System.Data; using System.Data.Sql; using System.Data.SqlClient; using...