Search results for query: *

Hi, My table (gift_history) looks like this: donor_id number gift_date datetime gift_amount number query looks like this: select donor_id from gift_history where donor_id= 3890 And gift_date between '01/01/1991' and '01/01/1992' group by donor_id having sum(gift_amount) between 15 and...

Hi, I have a form that inserts data into an access db using an autonumber column. It passed QA, but in production I'm getting a lot of skipped autonumbers. is that normal? I have all input validated and errors trapped.

is a specific exception thrown if an insert into an access database via oledb causes a violation of a unique index?

Hi, I'm inserting about 500,000 records during which i'm converting a string to a date. I get an error: Server: Msg 8115, Level 16, State 2, Line 1 Arithmetic overflow error converting expression to data type datetime. The statement has been terminated. How can I figure out which records...

Hi, Any advice on the problem below? I have a 4 digit string representing a date which I can sucessfully convert when the year is prior to 2000. But, after 2000, I get a syntax error. select convert(datetime,(substring(@date,1,2) + '01' + substring(@date,3,2)),101100) 1999-01-08...

are there any freeware packages that can be used to create ER diagrams? nothing too fancy, but preferably something that can generate a script.

hi, i have a procedure which occasionally generates the following error: Server: Msg 8152, Level 16, State 9, Line 112 String or binary data would be truncated. The statement has been terminated. is there any command I can issue prior to running the script so that such truncations would be...

I have a script which uses a cursor (cursor use is not the topic though :)). There are some records that, for various reasons, cause an errors such as: 1. can't insert null 2. data would have been truncated 3. eetc which cause the statement to be aborted. My question is: what construct do...

Hi, So I'm trying to embrace the "cursors are evil" mentality while doing some dataloads. My question is this: Say I'm inserting 10 rows from a query into a table. The first 9 have no problems, but the last has an error because it has a null value, or an arithmetic overflow, or whatever...

Hi, I have the following snippit: select case addr2 when charindex(addr,'@') > 0 then null else addr2 end as addr2 from members when i run it i get: Server: Msg 170, Level 15, State 1, Line 2 Line 2: Incorrect syntax near '>'. what gives? addr2 is a...

Hello, I have a ton of data that i need to import from one table to another database where the data will be split across multiple tables. additionally, the data needs to converted because whereas in the one table a column may be text, on the insert an id for that text value will be inserted...

Hi, I have an array with two cells. The first cell is the name of a variable and the 2nd cell has the value that i'd like to assign to that variable. How can I do this? Thanks, RP

where might i find an easily configurable, freeware, data-driven menu suitable for an ASP application?

Hi, Suppose you have: <input type=text name="element[]"> how can you pull that value into javascript? document.formName.element[].value returns and error. thanks

Good Morning, So I this snipit of code from one of my pages: <tr> <td class="sectionHeader1" style="background-image:url("images/text-1.jpg");"> <div style="margin-left:18px">My Name Here</div> </td> </tr> which does exactly what i want it to do in any text editor. and when i first load...

Hi, I need to teach some folks how to write stored procedures. They already have a concept of stored procedures and can write very simple procedures to select data. I'm trying to find some examples that I can give them of more complex procedures, or some sort of tutorial/lesson plans that are...

Hi, Is there any way to use the image.getthumbnailimage method whereby you always create the thumbnail from the main image even if it has an embeded thumnail? thanks, rp

Hi, In Visual Studio can you change the order in which something is listed or remove it from intellisense? Whenever I type "response.write(" intellisense causes "response.writefile(" to be written instead unless, once the intellisense context is visible, i hit the up arrow key one time. it...

Hi, when using the cfquery tag, when does the query actually execute? does the mere presence of the tag execute the query and store the results for later use, or is the query executed when you take some action on it, such as a cfloop? assuming that the query is not executed until you take an...

Hi, I have the following webservice: Imports System.Web.Services Imports System.Data.SqlClient Imports System.Data <System.Web.Services.WebService(Namespace:="com.catalystsolves.northwindCustomers")> _ Public Class Customers Inherits System.Web.Services.WebService #Region " Web Services...