Search results for query: *

Hi, Is there a way to detect when a page is reloaded or prevent a database update on a page reload? I have 2 pages, page1.cfm and page2.cfm. page1 submits to page2 and page2 updates the database and displays some information. I want to prevent page2 from inserting data in the db again when F5...

Hi, I'm using asp.net (2.0) to build a menu in tab style. Right now i have 3 tabs. I want each tab to have a different color but can't figure out how. Right now in my CSS, i can only set a color for the tab that is selected and another color for the ones that are not selected. Any ideas...

Hi, I've got this pretty big query (lots of fields and inner join). Running the query takes between 2 and 4 seconds. But, i only want to get 1 row. I tried TOP 1 or SET ROWCOUNT 1 but those just make my query run in about 30secs! Is there something i'm missing here? I want to get 1 row...

Hi, I have a DTS package that i use to import data into a table. It has 2 global variables (strings). The data files are stored locally on the server before the package is run. I'm getting the following error: Step 'DTSStep_DTSDataPumpTask_1' failed Step Error Source: Microsoft JET Database...

Hi, I have a CR8.5 report in VB6. I've added an on-demand sub-report. When i run the report and click on the "link", the subreport doesn't open. I can't find out why. I've checked everything i could think of: the links, the query, etc, etc. Any ideas? Thnx

Hi, I have an application that connects to a db, does certain things and sends an email. Just switched to a new server running windows server 2003. Now, the app is not working because mswinsck.ocx is missing (that's the error i get when double-clicking the exe). I tried putting the...

Hello, I'm trying to insert column data using a DTS. I need some ideas. This page is close but not quite what i'm trying to do. (http://www.tek-tips.com/viewthread.cfm?qid=910282) I'm importing data from an access database to sql server 2000. The table is already created in sql server with an...

Hi, Is there a way to find which table column was modified? I'd like use that information to create an audit table. e.g. Let's say i have a table with col1, col2, col3. I'd like to use an update trigger to insert into my audit table: date, user, colName, old value, new value I need to find...

Hi, I'm wondering if it's possible to pivot a table without having to use aggregate functions? I'm using MS SQL 2000. Basically, i want to have my table normalized but use a query to pivot it. e.g.: Table in database: name A B ---- ---- ---- X 1 1 Y 1 0...

Hi, I'm trying to figure out if it's possible to sort a popup menu programatically. I need to sort my popup menu because i change their captions depending on language. Using VB6. Thanks

Hi, I have a dialog based mfc application. The first dialog shows up find with the taskbar "button/icon". But then it goes away when i hide the first and show the second dialog. i.e. my application is running but i don't see it on the taskbar. Here the code i use on an OnOk button click...

Hi, I need some guidance here please. I wrote a dialog-based application using MFC (VC++ 6.0). I'm trying to add database support but i have no idea how. I keep reading about using the CDatabase, CRecordset, etc. but where do i get those files? I can't seem to find anything helpful on the...

Hi, Got a little problem, can't figure out how to fix it. I have a table field as 'float' and with value 0.635642 When i display this field in CR8 report, it shows only 0.63 (It's like that when i browse the field values withing the report) When used in a calculation, the correct value of...