Search results for query: *

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

That'd be going into a wrong direction, saving a date value in a string would limit you in a lot ways.

I'm using both Access and MS-SQL for this app, though the dates ARE saved correctly, but as soon as I fill a recordset they get screwed. I don't really think that the SQL convert will help much, but I'll give it a try.

Where do you set the default format ? Taking it apart won't work because ASP already thinks the days are month and vise versa so I'd end up with the same date, plus it only screws up when days are less then 10, if days are say 22 (of March) the date will show up correctly.

Hello, I have a strange situation with a script I wrote. I have a script that uses dates extensively, user can select a date from 3 drop down menus (dd/mm/yyyy), save it to the database, then the entry is queried for specific date and then the entry is displayed. (In a nutshell :) Now when I...

I do love it so far :) Saves on code I have to write, separates the application logic give me more power it's faster and more organized .... no reason not to use it :) One question though, how difficult is it to port MSSQL SP's to say Oracle SP's ?