Recent content by DiverMarv

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

It's easy to recreate: <cfform> <cfinput type="datefield" name="date1"><br><br> <cfinput type="datefield" name="date2"><br><br> <cfinput type="datefield" name="date3"><br><br> <cfinput type="datefield" name="date4"><br><br> </cfform> save that to a template, and then click on the first...

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

Ok everyone. I'm very sorry to have wasted your time. But I have made yet another very stupid mistake in my life. The database I was using for testing is NOT a 2005 database, it's a 2000 database. I appreciate everyones input, and I did learn about the improved ability of an actual 2005...

Wow, I appreciate all the information supplied! And I also appreciate the comment about the feasibility of storing images in database! Now, mrdenny, I have tried "OPENROWSET BULK" and I get an error: Here is my particular sql statement: INSERT INTO dbo.ProviderPhotoJoin (photo) SELECT * FROM...

No, I do not have them in the database yet. But I do have a row that they will go into. So I wanted to do an update table instead of insert into table

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

The ISDATE() function is part of sql server. '6/2005' is not a date, but '6/21/2005' is, and '2006' is. Oh, and the error I'm receiving is: Server: Msg 242, Level 16, State 3, Line 1 The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

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 forgot to paste in my error message! I get this when I try to run the stored procedure based on the assembly (compiled from the code in the previous post). This is in SQL 2005 Server Management Studio: A .NET Framework error occurred during execution of user defined routine or aggregate...

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