iam having problem ,relating to update a column in Access file in ASP
'Change' is column name , rs is recordset object ,and i want to update the values in 'Change' column by return values from a function .Iam using vb script in asp
rs ("Change").value = function()
this is generating error, and won't work
I'm getting this error message: Error Type:
Microsoft JET Database Engine (0x80004005)
You cannot add or change a record because a related record is required in table 'employees'. Code:
I have a simple table "Line" with Columns Key, OrderNumb, Panels, Gates, Posts, Color, Memo, Comp. A user enters the information into the powder.asp page. It is then added to the database. The Comp Column is populated NO by a hidden input type. The data is then displayed on a page in a table and the last column has a submit button.
When the user Presses that button I would like it to update that record in the database to change Comp to YES. Some code snipits are below. The first is where the data is presented and where the submit button is. It then will go to the next snippet that hypotheticly will change just the Comp on that record to YES. I am not sure if I am not executing the SQL correctly or something but it will not change that order number row comp to 'yes'. Code:
I have virtual directory where I run test.asp page with only this code inside:
<%Response.Write now()%>
As a result, if I go into the IE and browse for the test.asp page, I get :
1/22/2004 14:18:04
If I copy this page on some other(existing) virtual directory, I get as a
result 22.1.2004 14:19:06
If I create a new virtual directory and I copy the page there, I get :
1/22/2004 14:18:04
Seems like that IIS takes english date format even if my regional setting is
:
d.M.yyyy and I would like that date on the page is always like this:
22.1.2004 14:19:06
Where I can change this setting?
I have an insert record form that posts fine to a db which automatically creates an ID how could I get the next page to do a preview using the ID just created by the DB to go to the right record?
View Replies View RelatedI have a .asp page which lists a date, then a bunch of record lines for data that falls within that date, then the next date and it's bunch of data record lines. e.g.
Ship Date: 04/06/04
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Ship Date: 11/07/04
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
What I want is:
Ship Date: 04/06/04
1: Data xxxxxxxxxxxxxxxxxxxxx
2: Data xxxxxxxxxxxxxxxxxxxxx
3: Data xxxxxxxxxxxxxxxxxxxxx
4: Data xxxxxxxxxxxxxxxxxxxxx
Ship Date: 11/07/04
1: Data xxxxxxxxxxxxxxxxxxxxx
2: Data xxxxxxxxxxxxxxxxxxxxx
3: Data xxxxxxxxxxxxxxxxxxxxx
How can I get these numbers printed againsts the records ?
if it is possible to change the location of the dlls of an application, by default, the assemblies of an application is loaded in the bin folder in the applications folder, can i change some configurations to save these dlls in another location?i'm using asp v1.1 and .net studio 2003.
View Replies View Relateddoes anybody here have codes for "change password"?i am using dreamweaver 8 and MS Access
View Replies View RelatedWith global.asa application variables can be set. Later can a script in your
application change the value of those variables. But when IIS is restarted
the old values are used again. Is there a way to get the changes that are
done into global.asa?
I need to generate a pdf file in classic asp script. It uses the arial font . But i need to change the font of the pdf file to Century Gothic. I am currently using fpdf.asp file to generate the pdf. Can anyone tell me how to change the font to Century? It would be pleasure if anyone could provide me the code for doing it.
View Replies View RelatedI want to have two pull down menus, 1 for continents and the other for
countries. On selecting the continent how can I change the menu of another
pulldown or how to display the list of corresponding countries in that. And if no continent is selected then nothing should appear in countries pulldown.
my management has now decided that wants the crystal report that I have developed to be available with 5 different options. The only thing really changing is the where clause of my sql statement that Crystal Reports uses in the expert wizard to create the report. All of the fields remain the same. Is there way to set parameters for sql statement that would changed "where" clause in displaying crystal report in crystalreportviewer to (where xfield=parameter1, x2field=parameter2, etc.)
View Replies View RelatedI have some dynamic pages like asp files and the data comes from database.
What I need is to display the page content to diffrent languages.
Suppose user selects Germany and the page content changes to german language.
With ASP is it possible to dynamically change the <title> tag depending on what record I am viewing? I know that you can do this isn ASP.net and PHP but was wandering if its possible in ASP too
View Replies View RelatedI just moved my website from a Win2000 server to a Win2003 server. On the old server, we would prompt for the user name and password via the WWW-Authenticate header, retrieve the Base64 values provided by the user from Request("HTTP_AUTHORIZATION"), decode them, and validate the user against our database.However, after moving to Win2003 server, the user is no longer prompted for the user name and password. The HTTP_AUTHORIZATION comes back immediately, and decoding it reveals a very long string of garbage.
Obviously something has changed between these two version of IIS. Anyone
know what the problem may be?
I have a html page that contain a form, I want to change windows registry, this key (LegalNoticeText) to amount of the text box in the form how I can do this?
View Replies View RelatedI have a combo which has 2 values.I want when its value is changed then its value should be display in a text box.
View Replies View RelatedI have been trying to use If Then Else Statements and CSS to make different table rows change to different text colors based on a field that is queried. For instance when displaying a row of data that has the Memo field marked as rework I would like all the text colored Red.I have 3 different instances that I need to work with. Can someone point me in the right direction to make this work?
View Replies View RelatedUsing a DetailsView to update data in SQL 2005, How do I change the default "Update" hyperlink to a more user friendly button?
View Replies View Relatedhow to change a string to upper case.
View Replies View RelatedIs it possible to change the dropdown values in a <select> tag based on the Server Variables LOGON_USER?For instance, if userA is the LOGON_USER, the dropdown would show option 1, option 2, option 3, option 4. If userB is the LOGON_USER, the dropdown would show option 5, option 6, option 7, option 8.
View Replies View Relatedi ussually use www.domainname.com?uid=1111 .this one use request.quarystring right?so, what is the logic to change to www.domainname.com/1111
View Replies View RelatedI have a site with a simple admin tool (cut and paste text into a form field etc)henever someone copies in text with quotation marks, dollar/pound signs and then submits it to the database, the text shown on the front end contains ? marks instead.I have read this may be due to special characters or something, is there anyway to stop this
happening or filter it out as the admin is for general use by registered people.
I have made a case for changing values in the recordset but when I click on the submit buttom nothing happens. Can anyone see whats wrong?
View Replies View RelatedWe want the currently date display in the input box (asp code), if the user wants to change the date, they can pick a diff. date from "date picker calendar". It picks the date...and it works fine.
When I try to submit, it doesn't submit the Date that I picked. I view the source code, it seems like it doesn't change the New DATE that I picked from the calendar. How can make its value change?
Is it possible to change a variable name? I need to store some information to be displayed to the users in a variable but I need to change the name of this variable. So what I need to do is read some info from the db, create a recordset and then read the first row of the recordset and store the result in a variable named Answer_1, read the next line and store the result in the variable Answer_2, is it possible?
I tried the following code:
Answer_"" & Counter & "" = "" & rsResult("Answer") & ""
But it doesn't seem to work.
let's say I have this string in the DB:
s=100,101,102,103
and also id=101
how can I change "s" to be "100,102,103" ?
I want to check a string for a certain value then change that value to something else.
Example, user types in a value in a form "jim" , some code checks to see if the letter "m" is in the string. If it is it changes it to "t".
But we don't know if the string is jim everytime. Sometimes it could be "mark" or "quagmire". But for any string with letter "m" i want to change it to "t". So "mark" would become "tark", "quagmire" become "quatmire" Is this possible?
i got an image hardcode linked to another webpage like below.
<a target="_blank" href="http://www.anysite.com">
<img src="picture.jpg"></a>
assuming it is an email i forward to many people every month. i want this particular image link to be "changeable" so that i can change it when i want to. instead of having everyone who receives this email change the link themselves.
i want to be able to go to 1 place n change the link so that every1 who has this link will see the new page i have linked it to. how can i do that?
I have been web-enabling alot of an access database with forms and asp. In the database, there is a field in the record stating weather it's open or closed. By default, the value is open. When the record is changed to closed, I want to have an email sent -- confirmation (record number and column values) page to the email address in the record.
I would like to have this automated and scheduled to run every night. It would go through the database to see which records = closed by "completed_date" type of thing. And each record that was closed have the email sent to address in the record. how this can be done?
dates are formatted according to the system date format. However, I have found that a couple of computers consistantly display dates in American format. I have had the techos check all possible areas for setting of dates and I am assured that the proper setting have been made.
Is there a asp command somewhere, I can use that will set all dates displayed as dd/mm/yyyy. I have got around this problem by using Day(),Month() and year() and formatting dates accordingly each time I need to display a date.
right now i am developing a web site. i want to know how to write the code to change the case for the text which we entered in the text box control? for example: if user enter his name as john elan, then we should automatically convert that text into proper case. i mean the name should become John Elan.
View Replies View RelatedI have domain name , eg www.abc.com. Use the Dynamic DNS web site to register.
If will show the IP of www.abc.com once I click The Domain Name. e.g. click http://www.abc.com.
Then show http://123.123.123.123
If the ASP program can help me? or any other solution.