Hi everybody Does anybody have a suggestion for a simple data access program? I've recently moved from sql 2000 wich I used with access ADP to sql 2005 ADP:...
Niels Bieze
nrbieze@...
Feb 1, 2007 3:31 pm
11969
Hi Dave, I do not know what is the user putting in as password. The password itself in the system do not have any invalid character. But I will find out what...
Hi Mokles, ... I think Dave's point is that if you're pre-processing the data at all before you pass it into the ADODB Command, you're probably using a form of...
Shawn, Thanks for your reply, i have managed to get it sorted, their was a multitue of things, you are correct i had to reassign permissions, copy the...
Mockles What Shawn has explained is certainly what I was thinking. Would you like to post the code that takes the password and gives it to the stored...
Hi Shawn, Thanks for your insight. I now understand what you mean. I got some RegExp example on the Internet for this purpuse. I will use the WhiteListing...
Hi list, Does anyone here happen to know of a good CSS forum, be it a newsgroup, Yahoo group, WWW-based message board, or anything else? Should anyone wonder...
Hello All: I am having problems with this query and was hoping someone might be able to help. As a forenote: this is ACCESS and not SQL Server, so I am not...
Well, to get all products - even those with no bids - you will need to an outer join. But ... I'm not sure how this fits with your wish to get only the maximum...
Just had a bit of a play. I couldn't get an outer join to work. But you don't really need one for this - you just need to find the maximum value for a product...
Hi All, i have one asp page (Page1) where i am showing some data in a table.there is a column in this table which is a hyperlink , when user click on the link...
Hi Anurag, ... What you'll need to do is set it up so that the opening window (the window which has the original link that allows the user to open the 'add'...
I'm a web designer much more comfortable in XAMP architectures than in dot-net. But, I'm now presented with a client who runs dot-net on their web servers....
I need to initiate a VB function to look for a value in a database. If the value is null or blank I want to wait for a given time and check again. I can do...
Hi Madòrick, ... If it must be server side you can use something like: ' make "nWhen" five seconds from now nWhen = dateadd("s", 5, now) ' now loop until "now...
Yes this would effectivly create a timer but, would also be burning cycles and if there were 100 people using this site, this would burn most of the processing...
Does anyone here happen to know of a good SQLServer forum, be it a newsgroup, Yahoo group, WWW-based message board, or anything else? I have 5 databases on...
Hi Lynn, You can backup the databases and resore them on the new server. You have not mentioned what version of Sql Server you are using, although it seems you...
Thank you both. Yes, I was thinking "copy" and not "backup". A full backup and restore will work. Thank you for putting my overworked mind in the right...
The old server was ASP and I have 2 mail applications: Comment and SendMail using CDONT. The new server is ASP.NET. The ASP still works with the exception of ...
Hello Guys: I was hoping someone could help me with this query. I will be very grateful if anyone is able to help. I am doing a website for our local Rotary...
with any luck you've three tables users items bids bids table has UID UserID ItemID Amount Timestamp So what you actually want to do it is type in a number and...
Hi, You do not have any join for the User table. Probably it will join with the Bids table. So, in the From clause, use something like: U.UserId = B.UserId ...
I found this wonderful scrip for Classic ASP on codebeach.com, but would like to make a change to it and I'm stumped. The script takes an RSS feed and writes...
Hi Malcolm, ... The easy way would be to use a counter inside and "exit for" when the counter meets your value. If it never makes it that far (four items and ...