Change Records
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
ADVERTISEMENT
How To Change Color For Row By Records
I load data from dtb and would be nice to have different color for loaded colors, e.g. blue and light blue. I don�t know how to make it. Here is my code which loads data from dtb: Code:
View Replies View RelatedWhen Change The Directory Then Date Format Will Change
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?
Systematic Updating Of Records Depending On Amount Of Records In Another Table
The problem concerns 2 tables, cart_products and cart_shoppingcart.
Cart_products contains all the product data (eg, prices, product's key name, etc), but most importantly, it contains the quantity of stock (prod_quantity) for each item.
cart_shoppingcart contains all of the user's items in their shoppingcart, including those that are part of an (customer) order; these have the order_number to differentiate from those that aren't in any order (their Order_number is 'no_order', the others have the order number).
Now, what I want to do is this:
For every item in the order (ie, every entry in cart_shoppingcart that matches the username and order number), take the quantity (x) the customer is ordering, then take the quantity of stock remaining (y), then subtract x from y to create the new stock level (z) and update the appropriate record in cart_products with z (all this with SQl preferably).
I was thinking of using a Do while loop, but realised that it wouldn't work as I'd have to use several SQL statements and then I'd run into a problem the minute ASP reads "objrec.movenext".
Pulling Records From End Of A Database Or Inserting New Records To The Beginning
I'm trying to pull the last 5 records from my database.
<% j=5
rs.MoveLast
While ((j>0) AND (NOT rs_article.BOF))%>
''Execute HTML and data insertion here
<%rs_article.MovePrevious
j=j-1
Wend%>
Everytime I attempt to run this code, I recieve an HTTP 500- Internal Server Error. It tells me no more than that. I know that my connection settings are OK because when I move forward through the database (first five records), the code executes without error. And yes, my Cursor type is Dynamic.
Alternatively, I would also like to know how to add new recordset to the beginning of a database rather than the end.
Grouping Records Within Another Group Of Records
I have an Access database with two fields that I would like to group by. The two fields are location and department. Field names are "Location" and "DeptName".
I have the code correct for grouping by location. That code looks like this: Code:
Change
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 RelatedWant To Change Record
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
Change Password
does anybody here have codes for "change password"?i am using dreamweaver 8 and MS Access
View Replies View RelatedIs It Possible To Change Global.asa From Asp
With 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?
Change The Font
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 RelatedChange Menu
I 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.
Change Parameters
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 RelatedChange Language
I 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.
Dynamically Change
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 RelatedChange In Request
I 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?
Change Registry With Asp
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 RelatedChange Text Value
I 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 RelatedChange A Table Row
I 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 RelatedChange The Default
Using 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 RelatedChange A String
how to change a string to upper case.
View Replies View RelatedChange Dropdown
Is 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 RelatedLogic To Change
i 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 RelatedCharacter Change
I 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.
Change The Date
We 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?
Change Variable Name
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.
Change The Line
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" ?
Change One Value In A String
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?
Change The Link
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?
Event Change
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?
How Can I Change My Date
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.
Case Change
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 RelatedChange Domain To IP
I 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.