Recent content by kunai

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

If you only need a simple report, VB6 has its own reporting capabilities. Look in Project/Components/Designers/Data Report.

Instead of CASE, try the isNull function. In your case, i'd be: select isNull(sopnumbe, order_num) as master_sop_num from yourTable

Nice tutorial.. i've already have that done. But i'm using the menu control. Not exactly the same. My tabs are generated from a sitemap. I think i'll change it now. My way is more complicated :) Thanks.

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

I'm not using Access, but for me, if a query works alone but not with the report, it usually means that some fields in the report do not match up with what the query is returning. Just a thought.

hmmm.. didn't think of that. The plan does change. With my two table: With TOP 1, the cost for Table Scan is 95% and 0% Without TOP 1, the cost for Table Scanc is 47% and 37%. There are also more steps. I'll take a look at that on Monday. For now i'm just omitting the TOP 1. Thanks for your...

Thanks. Maybe you're right Celeste. First time this happens to me though... even if this query is not the biggest i've written. I am doing a lot of convert and cases, etc, etc. I'll keep looking for something.

Ah. No, I don't have statistics set on my tables.

What do you mean by "update stats"?

Same with "option (fast 1)". Takes 30secs to return 1 row. Without anything, takes 2secs to return 8 rows.

The server isn't particularly busy. I did run it multiple times though. (In Query Analyzer, SQL server 2000) It's the same query everytime, same WHERE criteria too. Just weird.

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

Fixed it. The problem was that i was feeding the path and filename to my Dbase connection object. (thus the reason for the error). It only accepts the path. I used code to change the source: oPKG.Tasks("DTSTask_DTSDataPumpTask_1").Properties("SourceObjectName").Value =...

I've found out that the error is because my task isn't accepting the path to my dbase data file. I can't specify in the ActiveX code the filename. Anyone?