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 ...
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 ?
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...
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 ?
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...
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...
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 ?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.