I am new to ASP. I am using the free ezscheduler asp program to create a calendar for my website. The idea is for employees to schedule their work shifts online. I have modified some of the programmin from its original format.
Here is my problem. The information that people enter are going into a database as comma delimited. When the information is pulled from the database and placed on the website it leaves the commas from the fields. I do not want the commas.
Here is the code inserting into database: - strSQL = "INSERT INTO tbl_calendar ([schDate],[shift_time],[shift_type],[special_events],[other_hours],[employee]) VALUES ('"&strSchedDate&"',"&_
-
"'"&rplStringIn(Request.Form("shift_time"))&"','" & rplStringIn(Request.Form("shift_type"))&"','" & rplStringIn(Request.Form("special_events")) & "','"&rplStringIn(Request.Form("other_hours"))&"','" & rplStringIn(Request.Form("employee"))&"')"
-
Here is the code inserting from the database to the website: -
<td style="background-color:<%= strColor3 %>;color:<%= strColor6 %>" width="15%" align="center" valign="middle"><%= rplStringOut(rsCal("shift_time")) %> <%= rplStringOut(rsCal("other_hours")) %></td>
-
Here is what shows up on the website:
7am-7pm, or 4pm-,7am,
Can someone show me how to remove these commas? I am very new to this and so please make the instructions simple for me to understand.
Thanks!
1 1756 jhardman 3,406
Recognized Expert Specialist
1- what type of db are you using
2- show the code for how the script opens the db (to show data, not to add data)
Jared
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: gotcha |
last post by:
I would like to know if you can display only certain data into a field
between commas or any other symbol without using the curshort feature.
For example. I have the following.
Part, A3472, Desc: Controller: Price$ 45.00
I just need this out of it in a single form field.
A3472
|
by: David Sharp |
last post by:
Once I've converted my floats to chars using STR, is there an easy way
to put commas in separating the thousands.
i.e. convert
53000000.12
to
53,000,000.12
I'm thinking I'll have to do it with a user defined function and the
various string functions myself but was wondering if anyone had an
|
by: darren |
last post by:
Hello,
I am posting a html form to a php processing page, which produces a csv file
from the form data. However if the user inputs a comma then it screws up my
data.
So i'd like to know how to strip my data of commas before submitting to the
php processor.
Or maybe not strip the commas but handle them better.
|
by: AES |
last post by:
Encountered a URL containing a comma the other day -- the first time
I've ever noticed that, so far as I can recall. It worked fine,
however, and I gather commas are legal in URLs.
Out of curiosity, did a quick scan of an ASCII file of the 542 URLs in
my personal bookmark file and discovered exactly 3 that contained commas
(two with a single comma, one with three commas) -- so I guess they're
pretty rarely used, even if legal.
Seems...
|
by: Drew |
last post by:
I have a permission tracking app that I am working on, and I have made the
insert page for it. I am having issues on how to prevent duplicates from
getting entered.
Currently the interface for the app has a mixture of select boxes, list
boxes and checkboxes. The form submits the page to processAIMR.asp and then
does the inserting. I am using a loop to insert a new record for each
checkbox checked or listbox entry selected.
My...
| |
by: Steve |
last post by:
Hi,
I have a table which contains records of user access and searches made
within an application, this is a sample of the data:
response for 101 results from database in 28906 ms
I only want to keep the text contained in the brackets and nothing
else.
|
by: striker |
last post by:
I have a comma delimited text file that has multiple instances of
multiple commas. Each file will contain approximatley 300 lines. For
example:
one, two, three,,,,four,five,,,,six
one, two, three,four,,,,,,,,,,eighteen, and so on.
There is one time when multiple commas are allowed. Just prior to the
letters ADMNSRC there should be one instance of 4 commas. (
,eight,,,,ADMNSRC,thirteen, ). The text ADMNSRC is NOT in the same
|
by: Mike P |
last post by:
I am trying to write a csv file to a database table, but the problem is
that several fields have commas within them, so the code is reading the
commas as the end of fields. My code is below. How do I get around
this?
Stopwatch stopWatch = new Stopwatch();
stopWatch.Start();
StreamReader sr = new
StreamReader("\\\\devext02\\Xerox_Upload\\archive\\" + strFileName +
|
by: Adrienne Boswell |
last post by:
Although this is a client side issue, I am also posting to asp.general
in case there is someway to do this only server side (which I would
prefer).
Here's my form:
<form method="post" action="<%=request.servervariables("Script_name")
%>"
<% for i - 0 to 4%>
Header: <input type="text" name="header" id="header<%=i%>"
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |