I want to learn to manage my Access database schema (add tables, drop tables, add columns, etc.) remotely by accessing it through ADOX. Microsoft's online documentation is OK, but the code samples are buggy and they're in VB, not VBScript.
Can anyone point me to:
A) ADOX documentation on the Web that's better than Microsoft's
B) Downloadable code that uses ADOX for schema maintenance.
C) A good book on ADOX programming.
I intend to make an online shop for a few web sites.
I would like to build it myself from scratch in ASP.NET using VB.
I don't want to buy any software etc because I would like to gain the experience of building it myself.
Can anyone recommend any good books / web sites / articles that will guide me through the process. I like WROX Press but don't know which books will suit me best.
Is there a place online that that provides a glossary of ASP syntax?
I need a place that will briefly explain the meaning of ASP code such as:
DIM, IF, ELSE, sub, Response.Write, etc.
can't seem to get this ADOX code to add columns to existing Access 2000
table what's missing ?
Sub AddTableFields()
Set tbl = Server.CreateObject("ADOX.Table")
set cat = Server.CreateObject("ADOX.Catalog")
cat.activeConnection = conn
With tbl
.Name = "events"
Set .ParentCatalog = cat
.Columns.Append "MaxEntries", adInteger
.Columns.Append "CurrentEntries", adInteger
End With
cat.Tables.Append tbl
Set tbl = Nothing
Set cat = Nothing
End Sub
Here is the code I'm trying (but it errors out with "Item cannot be found in the collection corresponding to the requested name or ordinal."):
objTable.Columns(s_name_field_to_delete).delete
AND SAME ERROR WITH:
objTable.Columns.delete s_name_field_to_delete
AND SAME ERROR WITH:
set objColumn = objTable.Columns(s_name_field_to_delete)
objTable.Columns.delete objColumn
What am I doing wrong?
any good books thats any of you've read to learned to get started with classic asp?
View Replies View RelatedI have some simple asp work coming up in the near future and was wondering if anyone had some recomendations on books. I'm a bit of a newbie to ASP. I've done a bit with vb.net and asp.net using vb.net but I havent really used classic asp. If you guys could reccomend an into to asp book and a asp to asp.net conversion book I would appreciate it.
View Replies View Relatedwhat the best ASP books are out there, lookin for more of a definitive guide really with everything in .
View Replies View RelatedI'm looking for a good asp.net book to buy that includes some details on installing & setting up a server from scratch as well as the regular programming lessons.
I have plenty of experience in php, so I dont need too much of the programming basics. Any reccomendations for intermediate level books?
Does anyone know of any good ASP books in PDf format?I am new to ASP and I would like to do some reading on the subject.
View Replies View RelatedI am fairly new to ASP and I was wondering if any of you guys had some recommendations for books for beginners for this?
View Replies View RelatedI am looking to learn Classic ASP and was wondering if anybody could recommend any good books for learning Classic ASP from scatch.
View Replies View RelatedI've just ploughed my way through Beginning Active Server Pages 3.0 by Wrox Press (and i have to say it was pretty good. Easy reading, easy to understand. I get really bored reading, but found myself wanting to read the whole book, anyway...) I need to be an ASP expert (well at least write decent scripts that work !)
Kevin Yank reviews both Professional ASP pages & ASP 3.0 programmers reference and gives 5/5 for each. Has anyone read both of these two and could suggest which is the better?
Does anybody has a Sample of books library systemin ASP? I looked for in aspfaq.com, asp101.com, but untill now I could find anything else.
View Replies View Relatedhttp://webdev/wrox.co.uk/books/1797 link is not found.
i need to the script for the sql db custom sessions table portion.
I want to build a website with a members only section using ASP and an access database, can anyone tell me a website or recommend a book to help me do this?
View Replies View RelatedWhere I can find an ASP reference (objects, methods and properties) like the one that PHP offers in his site?(downloadable and .chm format preferable)
Please don't tell me microsoft.com, be more detailed please because I've been searching for on microsoft.com ...but nothing found.
I'm writing a custom COM object used by certain pages on a site. During
development, I need to replace this dll periodically, but have found that is
in use and can't be replaced. This is true even after all browsers have
been closed, and sufficient time allowed for a session to expire. The only
thing I have found that works is to restart IIS thru the IIS mgmt console.
The object is used like this:
var vObject = Server.CreateObject('MyObject');
//do something with it
vObject = null;
Is there another way to replace this dll short of taking the entire site
down?
i need to download some good free ebooks of ASP, links please.
I'm trying to convert some ASP pages to PHP, but I don't know ASP very well (as in: at all ), and there are calls ASP is making whose purpose and function is unknown to me. I tried looking for a reference on the web where I can search any function name and get a reference to what it does, but I have been unable to find it.
Is it somewhere really obvious and I just missed it like an idiot? Is there such a site out there at all? I need to translate ASP to PHP and as such need to read it, not write it, so a index/reference sort of site would be better than a learning ASP sort of site.
As my site and folder structure are becoming larger and larger - I am not quite sure how to reference files in a very different part of the folder structure. Is there certain syntax I should be adhearing to?
I see a lot of " ./ " stuff - but I am not quite sure what it means. Is there any other sort of things like ./ ? If you have any advice or have a link that explains this.
the equivalent of fopen(PHP) in ASP and if so where can I read more about it? Also does anyone know a good reference for ASp where you can read about functions and so on?
View Replies View Relatedsuggest me a complete ASP reference site with all the featurz and fungtions of ASP clearly mentioned.
View Replies View RelatedI've been struggleing with this chunk of code:
for j = 1 to totalManagers2
Response.Write("# in J loop:" & j & "<br/>")
If Request.Form("j") = "on" Then
myToField = myToField + recipiant(j)
Response.Write("recipiant's email is :" & recipiant(j) & "<br/>")
validRecipiant = true
End if
next
My problem lies with line ' "If Request.Form("j") = "on" Then '...
Now on the first page, I have a form, which I dynamically populate a table, and for each row, I output an HTML checkbox. I assign the name of that check box to a # that is incremented within the for-loop that is outputting all the HTML table rows.
So I have check boxes with name attributes such as "1", "2", "3", "4" and so on.
My question is, on the next page, how do I tell if those check boxes are checked? I use the Request.Form("1"), Request.Form("2"), Request.Form("3"), Request.Form("4") and so on.
But as you can see, in my For-Loop, I'm just checking this...
Request.Form(1), Request.Form(2)...and so on ....
So I am ignoring the quotation marks...how can I include them so the code knows to look at the form for the name attribute of "1" and not just 1?
I�m getting the error with the code below [ line 179 is just after the �then�]. The code is supposed to complete an�a href to an image if it exists. Code:
View Replies View RelatedI wanna know all String function reference in ASP and ASP.net. Is any website provide this information?
and Is string function in ASP and ASP.net has same.?
I took over an ASP site and am having trouble uploading pics through the user interface. I get the following message:
Microsoft VBScript runtime error '800a01ad'
ActiveX component can't create object: 'SoftArtisans.FileUp'
/admin/UPLImage.asp, line 15
The line refered to by the message states:
upl.Path = "d:htmlusersusernamewebsite.comImagespages"
is there an sql command that allows me to select all rows where a specific field isn't called by other rows? To be more specific: I have this table for my categories. I want to be able to choose all the categories that don't have subcategories. The fields are
CaName
CaId
CaParent
So a category has a parent, so caParent = the CaId of it's parent. So is there a way to call all the categories that don't have children categories in my sql?
This is my VBScript function:
<script language="JavaScript" type="text/JavaScript">
Dim UN
Set objNet = CreateObject("WScript.NetWork")
Set objUser = GetObject("WinNT://my domain/" & objNet.UserName )
UN = objNet.UserName & " (" & objUser.FullName & ")"
</script>
How can I reference the VBScript Variable UN in my ASP code? <%=UN%> won't work because VBScript is on the client side and ASP is on the server side. If I have to post it on one page and read it on another, how do I do that?
I have different database connections that I use for DEV and PROD versions of our web app. I want to put the database connection string in one location so I only have to change it once when we push live.
So I put it in an include file and reference it in all my asp pages as:
<!--#include file="includes/db_conn.inc"-->
But this will not work with the global.asa page. How can I reference an include page from global.asa?
My web host has stated that If I want users to be able to write to my database. I need to store it outside my site folder. So I have a site folder called www and a folder next to it named database. If I insert my database into that folder how would I reference it in my html?
How do you say in HTML "leave the www folder and find the database folder?"
I have a database of UK postcodes with corresponding OS Grid references (easting and northing) but I need to convert these to longitude and latitude so that I can plot my postcodes on a Google Map.Does anyone know of a function which can do this?
View Replies View RelatedI have a rather large classic ASP application that uses relative references like
...commonconnection.asp
all over the place in about 60 pages. The application works OK on my XP Pro machine but does not work on a Windows 2003 Server. Is there a way to set the server to accept the reference to the Parent folder? Does it have something to do with IIS lockdown? Or IIS Version 5 instead of 6?