I'm looking for a statement that would be the equivalent to WHERE xxx IN(value1,value2,value3) in ASP/VBS. It is very handy in SQL, but it doesn't work in an...
Chris, What you are looking for is Select Case XXX case value1, value2 ... End select http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script5 ...
Hi all i would like to dim an array, and then convert a string into that array. the array should be dynamic. i have the code below, and i keep getting type ...
Hi Moshe, ... Use a variant instead of an explicit array and don't bother redimensioning it unless you're adding or removing elements after you've assigned...
Your code for counting the number of commas has a couple of problems ... Len(Replace(ShortNoticeProds, ",", "," & "*")) - Len(",") takes the length of the new...
I would assume you need some ampersands and proper quotes in the strings you are writing. Such as: response.write "<a href='d.asp?cno=" & rs("院系代號") ...
I am using Access Database for an ASP online employee directory. The dB has three tables: one is the main table with about 400 employee records. Within that...
Mr. Broyhill: It sounds like your queries are pulling back the wrong information, as it certainly is possible to do exactly as you say (having done it myself ...
Mr. Broyhill: I think you need to join the other two tables into your Query, as the [employee] table, as you have listed below would only include the ID ...
... You are only pulling data from one table. To get the values of the data from the child tables, you will need to do joins. [Non-text portions of this...
Ah ha Well silly me :) I will get to work on that! (my first time doing this -- surprise surprise, eh) ... From: active-server-pages@yahoogroups.com ...
... <delete a whole bunch of crap that I wrote> Sorry, read that completely wrong. Access is performing a join for you when you look at the database in Access....
Much simpler than that. Go to Access and construct a query that works, then go to the SQL design mode and grab the SQL. Regards, Dave S ... From: Gary...
When I query a dbf, I'm only able to do it after I've made a connection to it from MS Access. Access will create a file that the driver apparently needs in...
Thanks Dave! ... From: active-server-pages@yahoogroups.com [mailto:active-server-pages@yahoogroups.com] On Behalf Of David Smart Sent: Monday, December 12,...
http://www.ZestHost.com I Gig of space for only $30 a year I have been using them for a couple years and currently have five domains with them right now and...
HYPERLINK "http://www.impacthosting.com/"www.impacthosting.com I have never had a problem with them and they are very affordable but they are strictly email...
Your DBQ parameter looks wrong. In my open statements (Access) I have the full path and filename of the database, including the .mdb. I would expect that...
... No, here's a sample of DBF code from http://www.tutorialized.com/tutorial/ASP-and-DBF-database-file-connection/1967 Function OpenDBFConn(Path) Dim Conn:...
www.myhosting.com ... From: active-server-pages@yahoogroups.com [mailto:active-server-pages@yahoogroups.com] On Behalf Of tomcarr1 Sent: Tuesday, December 13,...
Thanks Chris, I hadn't realised just how different the DBF interface needed to be. I notice in the example that the select: "Select * from [Persons#DBF]" has #...
jodohost.com excellent support ... From: active-server-pages@yahoogroups.com [mailto:active-server-pages@yahoogroups.com] On Behalf Of tomcarr1 Sent: Tuesday,...
Shawn and David S - my thanks for getting back to me on this, it works great, just tried now. and my apologies for not getting back to you earlier! thanks...
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.
