Path9898
Last Activity: Mar 2 '12, 04:16 PM
Joined: Jan 6 '09
Location: TX
-
thanks for the reply, the issue is resolved. -
textarea reformatting question
I need to be able to convert the text from a textarea to a block of text and retain its formatting its formatting. The text in the textarea can be 10 words or 10 000 words so it’s a pain to work with it as a textarea. I have see several java scripts (http://corpocrat.com/2008/08/10/how-to-get-selected-value-in-textarea-using-javascript/ ) that can do this apparently, but I have not been able to get them to work.
The code I am using to... -
CroCrew, here are the 3 pages. thanks
add.asp
...Code:<%@ Language = "VBScript"%> <!--#include file="ops/inc_connectionstring.asp"--> <% Dim lngRecsAffected Dim strSQL Dim strcustomer_name Dim strcustomer_helpername Dim strcustomer_helperphone Dim strcustomer_departtime Dim strcustomer_arrivaltime Dim URLBusiness_GUID
Leave a comment:
-
It is a 3 page solution to show appointment times for customers. The first page (add.asp) to enter to the data, a second (edit.asp) to update the data and the third to display (display.asp) the page on a screen in a public area.
The selected value in the option field does come from the database row time value, but additional appointment times are available as options in case an appointment time must be adjusted to an earlier or later time....Leave a comment:
-
CroCrew, thanks for the reply, I hope this all makes sence.
here is the script I to determine the time on the local PC rather then the server time
...Code:<script type = "text/JavaScript"> function addTimeOption() { var customer_arrivaltime = document.FRMadd_customer.customer_arrivaltime; var thetime; var d = new Date(); thetimeFull = d.toLocaleTimeString()Leave a comment:
-
sill buggered...
I need more help with this issue:
In my mySQL db my column has type of TIME. When I enter a time the DB records it as ‘14:30:00’. When my asp page calls it and it becomes ‘10/09/2009 2:30:00 PM’. I use GazMathias’s code and replace the PM/AM to get ‘2:30:00’.
The problem is that if a user edits/updates the data on the page, the time gets recorded as ’02:30:00’ note that this...Leave a comment:
-
need the time, not datetime
hello, i need some help with getting time out of a mysql db.
I have a page that lets you enter in your name and submit to a mysql db. In the db the table row is called appt_time and has a Datatype of TIME, with default value of '00:00:00'. this works fine to get the time the record is entered, I do not need the date at all. A sample of the data is 'G .Beck', 14:30:00
Then i have a seperate page that gets this data,... -
Thanks for the reply Jared.
Does anyone else have any other thoughts?Leave a comment:
-
size of a select statement and cookies
My application runs a series of webpages (like a slideshow) using data out of a mySQL DB. The first page that loads runs a select statement and writes the results to a cookie. The cookie then provides the answers that the following pages need.
Currently the select provides 26 values that goes into the cookie. This number is set to grow by 30%. Through out the slideshow there are about 4 additional smaller selects that provide answers... -
Gaz U Rock!
Gaz, that worked fantastic, thank you very much for your time and help!Leave a comment:
-
add variable to the select list
ok, so i red up on this option and have spent a lot of time fiddling with it to no avail. so far i have used this
...Code:<script type="text/javascript"> var newtime; var d = new Date(); newtime = d.toLocaleTimeString(); var myselect=document.getElementById("customer_arrivaltime") myselect.options[0]=new Option("HereLeave a comment:
-
use PC time in a dropdown list
Hi, I need some help with time. I have a dropdown list that shows various times so the user can select the time most relevant to their needs, but the system pre-selects the current time
...Code:<% Dim MyTime : MyTime = FormatDateTime(now, 3) 'returns current date/time %> <tr> <td class="body" align="right"><strong>Select Time In:</strong></td>
-
I tired that using
but when I view the database I can see that only one ' gets saved into the cell.Code:"creative_text_data = '"& replace(request.form("creative_text_data")(x),"'","''") &"',
For example if I enter and submit "these cat's rock" I thought it would save "these cat''s rock" in the database, but it saves "these cat's rock"...Leave a comment:
-
Apostrophe Issue
Nicodemas, thanks for the update. I tried integrating your examples into my code and don’t think I have done it correctly. While the updated code does function and inserts all 11 rows of updates I am having issues with apostrophes.
Here is my new update statement
...Code:for x = 1 to 11 strSQL = "UPDATE tbl_advert_setup_creatives SET " & _ "creative_runtime = '"&
Leave a comment:
-
Nicodemas
I updated my code using your example and it works great! thank you for helping me. I am still keen to know if i am going about this the correct way though.
One issue i found was that if any of my text fields have a sentance in it like "hello, world" the split() chops it up. Is there a way around this?
PathLeave a comment:
-
purpose
the table holds information for a web based image and text slide show. The slide show duration, images, text, colors and animations are controlled by the settings entered in the page i have been struggling with
So there are the names of 5 different images, times that each images will appear in a web slide show, 3 different pieces of text, 3 text animation names. Then the data is selected and run in the slide show...Leave a comment:
-
maybe i am going about this the wrong way?
Nicodemas, thanks for your reply.
I think in my inexperience I am going about this the wrong way.I will try your solution ASAP, but what I am attempting to have is a webpage with 40 different updatable fields in it.
This is an upgrade to an existing (functioning) app I built last year. The difference is that the old app had 1 row of data with 42 columns in it. This limited me...Leave a comment:
-
database update issue
greetings.
I am having an issue with a piece of code, I was hoping someone can show me where I am going wrong. Basically I select 9 rows of data out of a table that have the same item number, but each row has a unique GUIDs, then I loop through the data to display it on a webpage. This all works fine.
The issues comes when I try to submit all the data (changed or not) back into the table. My submit code is below
...
No activity results to display
Leave a comment: