i have some code that seems simple enough but is giving the wrong result and i'm going batty:
If Month(Date) = 1 Then
myMonth = Format(Month(Date) + 11, "mmm")
Else
myMonth = Format(Month(Date) - 1, "mmm")
End If
For January, myMonth should be "Dec", but it keeps showing up as...
i am developing a dynamic asp website for business purposes and am wondering if i can use msaccess 2000 db, or is there some legal issue regarding this? i can't seem to find a clear answer on the net. if i have to convert to another db, i'd rather do it now than later.
sorry if i'm posting to...
This is my current connection set up with a DSN:
Dim conn, strSQL
set conn = server.createobject("ADODB.Connection")
conn.open "sand1"
I had just been reading about how Jet is better using a DSN-less connection.
anyway-back to my problem (thank you by the way-it worked...
when it gets into the else, it's trying to update the personid field and i don't want it to even look at personid in either scenario. is there an "else if" that can be used here to prohibit personid from being looked at in the else?
thanks so much:)
also, could it be my connection...
I have a web page utilizing asp, vbscript, msaccess 2000.
Here is my code:
First version (this works fine):
<%
for each Field in rs.fields
for k = 0 to UBound(arrSand)
if Field.name = arrSand(k) then
SQL = "UPDATE sand SET " & Field.name & "
= 'True' WHERE(sand.personid =...
Is there a way to dynamically get a column name from an access 2000 db in asp, using vbscript?
Like a COL_NAME function or something?????
THANKS IN ADVANCE
thank you sooo much, you have pointed me in the right direction and i'm going to try it. wish me luck and please keep an eye out for my posts as they will undoubtedly related to this. i've almost got it now and i couldn't do it without the help and patience of people like you:) thank you sooo...
thank you so much-it seems like you understand what i am trying to do. now with what you said about checkboxes... i like that idea, but can i get the same result with a listbox. in reality, the user will have 50+ choices and aside from space being used, it will take time for the user to check...
i am using access 2000 db, asp forms and vbscript.
here is my question:
i want to get some bits of information (name, email) from a user via a form. I want to then insert this info into an access 2000 database via an asp processing page. this part i have accomplished using one table, one...
Thank you so much- I can't tell you how that's helped. Now can you tell me what the INSERT syntax would be and how i can test each item selected against an existing database field header (column name).
Do I have to use case statements or if-else statements and test each item against every...
I am hand-coding (no FrontPage or Dreamweaver) an ASP, VBScript, JavaScript, MS Access 2000 dynamic web site.
Here are some code excerpts:
form1.asp
<label>Please enter name:
<input name = "deliName" type = "text">
</label>
Please select all sandwiches that you make...
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.