This info from Sybase and not checked on Access, but it should presumably work ... You need a sub-select in the where clause that selects the highest bid for...
John: Thanks, but unfortunately I am unable to use a MAX function, as the other SELECT criteria are not part of an "aggregate function." Thanks Andy ...
Dave: Thanks for the help. This sure does help in a big way. I appreciate the time you took to help with this. Thanks Andy ________________________________ ...
I'm new to asp .net.... I have a database with fields indicating which pages/functions that a specific user should have access to. What is the best method to...
Hi, i have this error message. Error Type: Microsoft JET Database Engine (0x80040E14) Syntax error in FROM clause. /emovie/approved.asp, line 49 My coding is...
You should probably do a "response.write MySQL2" and see what statement is that is being run on the engine. You may spot the problem right away. ... [Non-text...
I have a set of ASP pages which generate a list from two Access 2003 dbs, and display it. When I put copies of the pertinent files on either of two hosted...
My guess is that your reserveid variable is empty, but as Chris suggested, you need to response.write out the SQL statement and see exactly what is being run...
I'm using ASP JavaScript and have this problem. In the database MyRs ("Title") = "Final Destination". But after running the code below textbox value is "Final"...
Do a view source and you'll see <input type=text name=newtitle size=25 value=Final Destination> You need to enclose the value in quotes, or the browser will...
Hi I am really new to ASP and just can't seem to grasp it. I would very much appreciate any help anyone can give me. Basically I have the following page, ...
This is ASP 101. Download a tutorial or two and work through them. Regards, Dave S ... From: tyler_troy25 To: active-server-pages@yahoogroups.com Sent:...
hi, when the session expired, i got the Exception error, how to avoid it.Then how to catch exception like java in asp. plz help me ... Yahoo! Messenger with...
You haven't told us what error you're getting, or shown us the code which is causing the error, both of which we need to know to help you any further. For...
I'm having problems with a asp page / query which retrieves articles from a table where the date is less than or equal to now (ie. the date is a past date, or...
I'm having trouble getting to the bottom of what you're doing, but a few things stand out as needing to be looked at. Firstly, please do a response.write of...
The following SQL works fine on both the test server and webhost: strSQL = "SELECT ArticleID, ColumnID, ArticleTitle, ArticleSubTitle, ArticleSynopsis,...
Hi, ... few things stand out as needing to be looked at. I'll upload the entire page to the files section. ... include that as well as the original code. Test...
In your two SQL response.write's you have dates of #4/12/2006# and #12/04/2006# so one is presumably looked at as a December date while the other is looked at...
Passing off the Now() call to the database server will eliminate the confusion, as the database server is parsing both sides of the <=. I can't remember...
Good afternoon group. I realize this may be a bit off topic, but I think this question may be useful for the rest of the group (as well as myself). I am ...
hi friends, i am doing a small project in asp environment, in that i want to get the photos from the customers and stored into database, atlast i want to...
Certainly. Please post the code you have and point out what is not working. Regards, Dave S ... From: bharani dharan To: active-server-pages@yahoogroups.com ;...
Hi, Can't help with "Contribute", but if you are happy with an open source option you could consider FCKeditor ( http://www.fckeditor.net/ ) ... it works...
I don't know how soon you are thinking of, but this is a direction I am considering for my business server. I am in the middle of installing the software but...
You need to specify a default value in the table design within MS Access... If you look at the field options in the design table window, there's a default...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
