Recent content by CzechNET

Hello, I have a window that has a textbox in a form called FRM, now from this window I have a pop-up that contains an image. When this image is clicked the textbox in the parent window would have a value "Something" (example). Is this doable ? If so can you point me to the right direction ...

Thanks Rudy :) I think it's exactly what I was after, it gives me the fields I need but only form records that have a unique email address. Thanks.

I have a query like this: SELECT fldUSERNAME, fldPASSWORD, fldNAME, fldEMAIL FROM MY_TABLE Now I'm trying to return only those records with a unique email addres, so no email address would be repeated twice. How would I go about it, somehow use the GROUP BY ?

Thanks r937 !

Thanks r937, works great on MSSQL. Do you know of equivalent for MS Access ?

Oh, right .. MS SQL server, though I'd preffer if it was in ANSI SQL, not T-SQL

As in ? Variable = "SELECT TOP " & MY_COP & " FROM ....." Eitehr way convert to stored proc ! It's going to be for the best :)

Anyone ? Please :)

The DB I have to work with has 2 fields (among other) "fldSTIME text(8)" and "fldSDATE DateTime" Now, I need to sort the records based on the date which works fine however I'd like to sort it by the fldSTIME as well, where the fldSTIME gets converted to time and attached to the fldSDATE. The...

Thanks

I have a table that looks like this tbl_name ------- ID fldCATE fldSOME and I need to find out what's the most occurring fldCATE value (it's an integer btw)no matter the rest, so say if value 5 is there 60 times while value 1 is there only 25 times, the value 5 should be returned. Any ideas ?

Simple :) Thanks

Just wandering if it's possible to get the form field names dynamically, just as you'd get the form fields values .... for each obj in request.form response.write request(obj) & "<br>" next Above code will produce values, but not the form names, any idea how to get them...

Can't you set the cache to expire in certain time period, say in a few days or perhaps even hours ?

My 2 cents .. since you already are on the Windows platform, I'd stick with it, .NET is very powerful when used right and is actually quite easy to migrate from ASP to ASP.NET. Also if you are not familiar with the Linux/Unix environment you'd have to rely that much more on opinions coming from...