I have an Access Database consisting of 10 Tables 1,table10. I need to add a new column to an existing table (e.g., table 1) without affecting the existing data in other columns.
How can I add a new column to an existing Table via ASP programming.
i need some help to find a way to pas a asp variable in to the ssi include file commend
i have tryde to pass the varible like this:
<!--#include file="sets/<%=a1%>.asp" -->
that didn work for me so i tryed this way instead
a2 = "<!--#include file="sets/cenarion.asp" -->"
<%=a2%>
that didn want to wark either
im little lost how to get this to work im not sure if its even possible .
what im trying to do is pass the A1 varible to the include fille command couse A1 contains the name of the file. A1 gets its info from a request.querystring
what software do I have to use for doing programming in asp and php. Atleast I want to learn basics.
View Replies View RelatedI am developing a blackjack game which is multiplayer, multitable game in which 4 users playing on each table.
There are 8 tables like this.
I am generating random cards through my random card function. Main problem is that I want to track cards for avoiding repitition. I can use application veriable for one table . But how to do for multitable ? We can't track it on session side as well as application side as all tables are in one application.
Can any one tell me how many programming languages are there in the world? I tried to google it but could not really get an exact or complete list of them all.cheers.
View Replies View RelatedI think following code makes just one page Landscape. It restricts the range of document. But I can run this code in asp. How can I convert this macro code to asp code?
ActiveDocument.Range(Start:=Selection.Start, End:=ActiveDocument. _
Content.End).PageSetup
..Orientation = wdOrientLandscape
I am building a site that offers the purchase of information. Clients can view a limited amount of info then they are able to view each recset in further detail once they purchase it. I am running into difficulties of how to facilitate this. I am using dbquicksite3 to build the ASP (I could do it on my own but it would take much longer). I am using Access 2000 for the DB and this also seems to be limiting me somewhat). I want to keep it simple because it is not a broad reaching website (probably several hundred recsets of purchase info and hopefully several thousand customers). Anyway, the problem is that I have a search for the basic results, I have a basic results page but I cannot figure out how to allow users to access only the pages that they purchase right after they purchase rather than watching my email account and sending the query results back via email. I suppose I could built a 'watcher' app that could parse the email from paypal for the order number and query my DB for the paidinfo/basic info results, combine them and send out an email in response....
Is this the best way? I have a log in but 9 levels does not help considering I have hundereds of recsets of info that can be purchased and if I give access by levels they would be able to view all in that tier.
Why doesn't anyone ever have problems during the night when i'm not working and can post then? Why do karsh and vlince get to answer every question? And if they have jobs where they can post all day why can't i have their job?
Does no one out there feel like answering? Doesn't anyone program during the night? I know plenty of people that work the 2-10 shift, why don't they post at night? or do we need to wait for college kids to ask how to do their homework again.....It's getting to be that time of year.
What is the best or most used software for programming in ASP and/or ASP.NET? I will mostly use to program web pages. I like to know if Visual Studio .NET will allow me to program web pages using ASP and ASP.NET.
View Replies View RelatedJust started learning ASP, seems like lots of people use VBScript to program with. Though, I have spent the last year learning Java. Just wondering if I can use this to program with? along with its API's ?
Also, is it worth while to learn VBScript ? Is it industry standard or needed? Im guessing it is from the way its the language used in most ASP books. Any insight would be great.
I have 60,000 records and each row/record has one cell that contains additional 100-200 lines of data (tab delimited i believe) .. weird format. So what I need to do is extract those data in that one cell into separate records, duplicating the fields with it.
Lets say i have one record and the record has about 10 columns of data. Column C would contain about 200 additional lines of data. I need to extract that and insert new rows to insert these data into individual records.
guide me to start asp programming and shortest tips.
View Replies View RelatedMy page sends an email using CDO to a username pulled from a database as follows:
With cdoMessage
Set .Configuration = cdoConfig
.From = "Admin <admin@MyCompany.com>"
.To = rs("USERName") & "@MyCompany.com"
.Subject = "Notification #" & rs("subject_Num")
.TextBody = txtVar
.Send
End With
this works great so long as USERName isn't garbage. If there are bad characters in it that IIS doesn't like, it get an error '8004020f' at the .send line.
I was wondering if there was an easy and / or publicly available code snippet that could check the user name for special chars. Ideally, it would email me if there was a problem with the USERName rather than just strip the bad chars out and send it to whatever is left.
Formulae exist in an Excel spreadsheet, linked to a Word document (a standard letter that extracts the results from the Excel cells). We want user online to fill in a web-based form, these data to be processed according to formulae in Excel sheet and then a standard document (Word or similarly formatted) is emailed to the person containing just the results from the Excel cells. At no point will the person have access to original Excel or Word files.
The Excel and Word documents will change frequently.
It is desirable if there is a way to simply upload the Excel and Word docs and the online form and all other aspects of the system will change automatically to reflect these changes.
1. Person fills in form
2. Server processes data from that form and generated answers 3. Person is emailed a standard document with the answers in place
I have a problem with landscape pages in word document. I am creating a word document using asp programming. I want to set n. page as a landscape. But I can not do it.
for example I want to set first 3 page as a portrait then 4th pag landscape and then 5th page as a portrait again.
There is a code like ....
objWord.Application.Selection.PageSetup.Orientatio n = 1
But it set all pages as a landscape.
I just want to set only the active page as a landscape.
There is a macro option like makes landscape this point forward not all document. But I can not do this in asp programming.
How can I solve the problem?
i ask you to explain what is object oriented programmind and how to use it in ASP. what is its advantages?can i take some documents of you suggest.
i want to learn object oriented programming. i am already using functions in asp alot. i thinkobject oriented programming means Class for ASP. but what are differences betweenfunction and class.
is it possible for me to create my own classes and use them in web pages? Is this common with ASP. are there any ASP OOP tutorials you know of?
View Replies View RelatedI will save the word document in file system of server.
following macro code makes just first page landscape.
"wdSectionBreakNextPage" starts new section but I dont know How I ca
convert this macro code to asp?
I try to make just page landscape others are portrait in as
programming. I can do this by word macro but not by asp...
if anyone knew of a good book or website that explained in detail how to program a good username and password protection script for a website. It doesn't have to be anything great, just something that is a little secure and works.
View Replies View RelatedI have a pdf editor software which opens pdf files in edit mode. I am opening a pdf file through this software in my code. The code is as follows:
Process.Start(Application.StartupPath.Substring(0, Application.StartupPath.ToString().IndexOf("Eviction")) + "PDF Editor 2PDFEdit.exe", "F:Covenant.pdf");
But, I want to pass some data to be displayed in the pdf file. This software allows to insert some textboxes(with name given to each textbox) in the pdf file and save them.
So, when I open this pdf file through my code, I want some values to be displayed in these textboxes.
For the past couple of months we've been developing a fair number of sites and sub-sites for an intranet site using a mix of JScript and VBScript.
Personally I disklike ASP and consider it an inferior scripting environment compared to Perl, PHP or Java, and the only reason I consented to work on this project was that I could use JScript (hello!.. real hashtables, exception handling etc.).
The problem we're having at the moment, is that one developer only does VBScript, and I will only write large amounts of code if I use JScript. But various aspects of the sites are merging, and we're having problems passing varbles two and from VBScript and JScript. One hacked up solution i've used is as follows: Code:
I always heard the term "data/database driven programming" model in ASP database, SQL programming, and web programming circles. But I don't quite sure what does it mean? Does it mean the web software's responds are based on data request from the user? Just like in Windows, we call it "event-driven programming" model because the windows program's responds based on user's responses? That's why we call "data driven programming" ?
View Replies View RelatedI have aproblem to transfer a data from table x to table y based on id. Its mean when 2 table have same id all data table x must move to table y. I don't know which command need to use is it insert into or update?
<%
Dim conn
Dim rs
Dim MYSQL,MYSQL2
Set conn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
Set cmd = Server.CreateObject("ADODB.Recordset")
conn.ConnectionString = "DSN=prmm;UID=administrator;pwd=sa"
conn.Open
startdate=request("tarikh1")
enddate=request("tarikh2")
MYSQL = "SELECT * FROM table_x where paymentdate between '" & tarikh1 & "' and '" & tarikh2 & "'"
rs.open MYSQL,conn ....
I am trying to display the content of a Table called
'Order Detail' directly from the database (e.g., Northwind.mdb). I have the following commands:
Set tableSet = Server.CreateObject("ADODB.Recordset")
tableSet.Open table_name, DB_name, adOpenForwardOnly, _
adLockOptimistic, adCmdTable
where, table_name = ''Order Detail" Or
table_name = 'Order Detail' Or different variations.
I always get error on the second command with the following message:
Syntax error in query. Incomplete query clause
which I believe because of space in the Table Name. How can I resolve this issue? (working with file or table name with space)?
I have a table with many txt boxes which i have inside a form with a submit button to an update page which adds all the details to a db. The problem is i have a another table inside the first e.g. table 2. i want to be able to update table2 by clicking a second submit button that would update it. Is it possible to have a form within a form or how can i do it??
Also i need to update the entire table in one go. For exampple if i have 3 records in table2 i want to be able to update them all by clicking the one update button. Code:
I have the following code but this is inserting manually. I want to make a query from table 1 and automatically enter the records into table 2. What needs to be modified? Code:
View Replies View RelatedHave an app which dynamically creates table rows depending on records, these can be several hundred (don't ask). Hence a very long page at time. Each row includes a hyper link to a new page, and a link back to the original page.
Is there any method (maybe via js) where on leaving the second page l can redirect the browser to the table row the end user clicked on? Hence the bookmarking. Can do this via Visual Basic on the desktop app, but can't work it out on the web app.
I have a table produced with names across the top and services down the left hand side with boxes for numbers for people who recieve services then the info is written into a table in an access db. That works fine and here is that code:
View Replies View RelatedI have two tables. Table A has 20,000 records, Table B has 2,000 records. Table A is what needs to be updated from the data in Table B. Only some fields will be updated and of course, only some records - both tables have the same field as a ClientID so matching up records should be easy.
Anyways, been a while since I have used ASP to work on things like this but would like to work through this one. I understand the process I believe, it is just how to make it go on to the next record once it has finished updating the first.
Basically, I was thinking of having it set up to reaad the top record from Table B, update applicable data in Table A. Delete that record in Table B. Move on to the next.
Hello I have a page for registering users.
I am reciveing this error:
The following errors occured:
- An error occured. -2147217904 : No value given for one or more required parameters.
there are students and teachers. therefore I have 3 tables one for logins and one for staff and on for students.
I have a form designed to capeture the need information.
in the code I am runing an if and elseif statmetn to determin the tables. I then insert the userid and password into the login table.
then i enter the remaining information into ither the staff or student table. what i am trying to do is select the perimary number that is generated as the userid and passeword are enterd. and add this to the second table. Code:
I want MS Access 2000 database column of table 1 = column of table 2. This is what I was doing: Code:
View Replies View RelatedI have a database app that I'm building and displaying my results in a table.
I need to know for anyone who can help how to have one row say red and the next row say green for instance.
I have menubox that shows all the datbases in a directory. When the user highlights a database, the chosen value gets stored in an Application variable(its a control panel).
Id like this Application variable to populate another menubox with a listing of all the tables within the selected database. However, I'm having trouble getting these values and google hasn't been much help. Code: