i have a an apending query on access ,and this query copy the info from one table to another table, and its work preety good on access , but i dont know how can i link with asp so i can i activate it directly throw the asp
View RepliesI have an append query in Access that I need to run via ASP. The query is called Query 1 and if I use the execute(“Query1”) command the append query will work.
the append query is session dependent. It needs to get information from an order table to a checkout table but only for the current user. For example if there are multiple users I don’t want it to take everyone’s information that is on the site at the time, just the individual. how to solve this? I need something like:
Execute(“Query1”) where session(email)=(email)
i have an access db , and i make an append query which copy records from one table to another, and i want now to make an asp page ,i want the query run when i open it. so anybody have any idea about this code??
and i have a second Q which is similer to this , which is i want to make the same move (copy records from table to trable2) but this time throw asp , (without the appending query)
i have designed a website that is using an asp shopping cart script and has a flash header which i have designed to display different content depending on the query string that gets passed to it in the page url. now my problem is that my script has a lot of pages and there are many ways of going from one page to another as well as link as dynamicall generated.
what i im wondering is if there is away that i can make an asp page directly append a query string to the url when the server generates the page and sends it to the browser.
So basically if say i had a page called home.asp when i opened this page some code in the page would make the page serve as home.asp?page=home&content=logo which would make my flash script display content according to the query string it has received. Code:
how to query active directory from asp for user info? If so do you know of any good tutorials or example pages?
View Replies View Relatedi have a an access query on my db, and i want when i open the asp code .the action query run , but when i try to so it , by select *from actioguery ,it doesnt work, how to do this move?
View Replies View RelatedI am trying to access user info in a remote Active Directory Server with an ASP application. For testing purpose, I set up a test domain controller (Win2k Server) and installed Active Directory Server.
I am able to retrieve the user info with the program below when I run the program(http://testmachine/test.asp) on the test domain controller machine. However, if I run the program(http://machine2/test.asp) from another machine in the same domain (Windows XP), it returns empty record set. Code:
I'm trying to retrieve data on all users currently within our active directory system, and although i have had some success there is one field that i still can't extract the values from - postalAddress. I'm using the following code:
View Replies View RelatedI've been trying to append values to my XML file but I can't get it to work correctly.
index.html passes the values of a form to the new_user.asp file and I want it to write my members.xml file.
Once the xml file has been written and saved, I coded the ASP file to redirect to google, just to see if its working, which it does but the data has not been written to the XML file. Any ideas where I'm going wrong. Code:
i want to know how can i make an html page which i want to put on it a text box and near it a browse button , so when i click in this browse button ,it will search on my computer to select a file(a pic for example) and when i click ok , the url link will be on the textbox (its like uploading files techniqe)
the other question that i want to connect this page with an asp page that append this file(jpeg) to my database(sql server 2000) , the field data type is (Image) , so my Q that i hear a bout something called append chunk , but i dont understand it well , so any body have any simple sample for this.
I need to append a field to a dbase file as part of a web application using asp/ado. I'm trying
Set oRS = Server.CreateObject( "ADODB.Recordset" )
'ors.CursorLocation = adUseClient
'ors.CursorType = adOpenDynamic
ors.Fields.Append "Index", adChar, 255 , adFldIsNullable
The problem is that the routine runs fine with no errors but the field is not added. Can someone help me out?
I cannot append to a textfile. This is my sample code:
set f=Server.CreateObject("Scripting.FileSystemObject")
set obj_log .CreateTextFile"C:loglog.txt",true)
obj_log.WriteLine("Added schedule by [Name]")
f.close
obj_log.close
Set obj_log=Nothing
Set f=Nothing
The problem is the next time i execute these lines from an asp page, it does not append in a new line. I cannot figure out how.It just keep on overwriting.
I need to create a form with a textarea on an ASP page that, when opened, fills the textarea with the current contents of a field in an Access database, and each time the form is submitted, appends any new text added to the existing text in the database field. I can do this, but the text runs together when it fills the text area. Example:
Entry 1
Entry 2
comes back as
Entry 1Entry 2
Any suggestions on how I can maintain line feeds when I pull the appended field back from the database.
how to append a link so that when it is clicked on, the page calls itself with the appended link, setting an ASP variable?
View Replies View RelatedWith the following code I can create a new textfile if it does not exist, but it seems impossible to me, to append data to an existing file.
Dim objOpenFile, objFSO, strPath
StrPath = Server.MapPath("../smslog.txt")
Set objFSO = Server.CreateObject("Scripting.FileSystemObject")
If objFSO.FileExists(StrPath) Then
Set objOpenFile = objFSO.OpenTextFile(StrPath, ForAppending)
Else
Set objOpenFile = objFSO.CreateTextFile(StrPath, True)
objOpenFile.WriteLine "KundNr;Namn;Datum;Tid" 'header
End if
..
..
what I have done wrong?
I am using the appendToLog method to append a string to the log file, however it does not append anything. My code looks like this
<%
Response.AppendToLog "test"
%>
Logging is enabled for my current page.
I will be using a 2d array with a shopping cart in a session. What is the best way to just append another array to the end of the array each time easily? Code:
View Replies View RelatedI am querying a database using ASP and then capturing the results in recordset then I try to insert more values into the recordset through the means of code:
View Replies View RelatedI am creating a feedback section on the page. Is there a way I can take the user entered text and append a word file or in any other format?
View Replies View RelatedI am looking for some useful articles on creating a recordset and appending it to an already existing database (Access MDB). I am also looking for articles on appending fields to an already existing table.
View Replies View RelatedI'm trying to use the following script to copy the files from 'foldera' to 'folderb':
Code:
I'm trying to run a stored procedure on an Oracle database. I currently get this error message:
Error Type:
ADODB.Command (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/live/verify_3.asp, line 24
My code is as follows: ....
Quick query, does anyone know how I would go about appending one table to another dynamically?
For Instance I have Table A which holds office A staff And Table B which holds office B staff.
Both tables have an identical structure but hold different data. I want to be able to view them as one table. This needs to work dynamically as both tables will be updated regularly.
I have created a form for a pre-entry(s) into a race. The problem I have is getting the entry information into a table where every enterance can be viewed without having to use a database. Is this possible and how.
View Replies View RelatedI'm trying to append an already existent text file, simple enough, but it doesn't seem to be working Code:
View Replies View RelatedMy code retrieves a username and a password from a form. Then this information is compared to some usernames and passwords that are stored in a database. The important thing here is that the comparison must be case sensitive meaning that "passWord" is not the same thing as "password"
I have this code, working fine in access 2003
SQL = "SELECT * FROM users WHERE StrComp(username_column,'" & entered_username_in_form & "',0) = 0 AND StrComp(password_column,'" & entered_password_in_form & "',0) = 0"
but get the following error when I run it against my sql 2005 database.
[Microsoft][SQL Native Client][SQL Server]'StrComp' is not a recognized built-in function name.
I don't know the corresponding t-sql for the query.
i was looking into using active directory to authenticate users, how is this done? what is required to connect to active directory?
What is can you pull from active directory with asp?
I have a pretty resource intensive javascript page that I would like to try to make into an Active X program. I'm a PHP programmer and don't know much about ASP, but the research I've found is talking about using ASPX to create the application. Can anyone offer any suggestions about creating something like this, whether or not PHP can be implemented and where to start. My intention is to have my program be embedded into the browser.
**Originally posted in the PHP forumns, I assume a moderator moved it to the ASP forum. Now that we're here, a few questions
Do I need a different server configuration to run ASP? I'm currently running apache 2.0. An example of an ActiveX program I'm thinking of can be found on webshots.com. This site uses an ActiveX program to allow users to upload images through their custom application. It has functionality similair to that of some flash I've seen.
I'm trying to connect to the active directory using asp. I'm having problems with logging in, what happens is the username accepted is not the user logon name but the displayname is accpeted heres the code:
View Replies View RelatedWhat is "active content"? My ASP page just returns HTML....
I have a page with an .htm extension that has a form whose action
is an ASP page which generates a report after updating a database
with the form data.
Under Windowx XP SP2 the IE6 "Information Bar" has the message:
"To help protect your security, Internet Explorer has restricted this
file from showing active content that could access your computer."
Could anyone show me a sample, snippet, code chunk ... etc of how I can get ASP to find the Active Directory username based on a supplied email address?
For example: I want ASP to query active directory and retrieve the AD username for where user email address = 'whatever@whatever.com'
I just made a simple thing on my page that says Active Users: and the number by adding 1 to session_onstart in global.asa. It seems to work.
Is there a way I can have this store IP's of the active user, etc without using a database to store the stuff in?
My problem is my active control will download to IE6 sp2, but not download
to IE6 sp1. On IE6 sp1, ther is no popup to ask for download.