Both commas are added dynamically and can be trimmed on the fly. I tried using RTRIM(strSQL, ",") but this didn't work.I put the fields into an array and tried to add only commas to all but the last entry, but that also didn't work.
I need to create a string along the lines of "23,43,78,23" with no comma at the beginning or end of it. The data comes out of a table so i've created a loop to get the data and form the string :
StrRecip = "," & objRS("number") & StrRecip
This will give me something like : ",42,78,67,2,90"
Using ASP/VB I need to remove unwanted commas from the end of a field that will be use in an array. There are items in the field that are comma separated, so I don't want to remove them, just the end ones, could be anywhere up to 5 unwanted commas.
I'm importing data from a csv file but have the following problem.
It see any comma in a specific column as the end of the current column and move the rest of the values into the next column I.E Data from column 4 display as data from column 5.
I do know that it's comma delimited but would like to know if there's no way that I can distinguish between the commas in a column and the commas that indicate a new column.
Col1 Col2 Col3 Col4 Col5 Value Value Value Val,ue Value
I don't know if anyone has encountered this before. I've written ASP code to insert, update and delete records from Access and SQL Server tables before but this is the first time I face this issue -
I have a form that inserts data into an Access table. For a few of the fields, commas are getting inserted into the table. If the field is left blank, there is a comma inserted. If we enter data in the field, the comma is appended to the field value (eg: smith, )
The only thing different that i'm doing here from what I've done before is I'm inserting a larger number of fields into the table - 117 fields!!
Do you think the insert statement hasn't been written correctly?
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
I cannot use the cutshort feature because my part numbers are different lengths.
how to check got how many commas in this string? how to check beside the commas is space or not space? if the words beside the commas is space, i wan to remove the space? if the words got commas, i have to remove the space.
having problems removing commas from my form input. Have a form that is bringing back text strings from users. when it gets put into CSV file, any commas the user has entered get moved onto new rows.
how to avoid an error when calling data to a text form field that contains inverted commas? When I enter "inverted commas" into a text field on a form and save to my Access database, after save the text field appears to be blank but when I look in the database it appears as entered. The problem is when the text field calls the field it doesn't show if the text is encased in inverted commas.
For instance, in my form field 'title' I enter: Big Title "Yeah" After saving the form, all that appears within the form field 'title' is: Big Title Yet the access database itself shows: Big Title "Yeah"
I have a string --> 7,8,9,10. This string may contain more or less than 4 numbers. I want to separate each number and run an sql query for each number.
I am having a problem with a site that I am developing - my aim is for it to validate as XHTML Strict however, I am running into a couple of problems validating it; in my Response.Write ASP script, I am not including " 's to define page element tags as they keep throwing up errors in the page. Code:
I have a form on my asp page that sends data to an emailing script. I am working with other peoples code which is causing a lot of hassle. Is there any way of sending a Bcc address command from the form rather than the emailing script?
what do you think is the best way to implement an "add new row to table" functionalilty? am using asp(obviously )im currently using document.createElement with javascript, but im having a hard time retrieving the data.am also thinking if this is really the best way to do this.or if this would work with all other browsers other than IE...
how to add a password to using this connection string
<% set conn = server.createobject ("ADODB.connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("dat48372.mdb")) set rs = Server.CreateObject("ADODB.recordset") SQL = "SELECT Price FROM DABRadios WHERE (ID LIKE 6)" rs.Open SQL, conn showall=true %>
and I know that access table cannot have a picture in it, only a access form using OLE, but how do I get my asp page to display a picture for every record? The picture would be a picture of the product with the Stockcode as the filename - m001110.jpg?
I have an ASP page with a table that fills with records from a loop. Every row gets a link to another ASP page with data from the row. The link is written as <a href=newpage.asp?value1=xx&value2=yy .... and so on. Now I try to let the user specify a number that should be sent to the other page. But I do not want to clutter up every row with each an input field, so I thought instead I would place it above all the data rows. When the user clicks on the link, I want to include the input field to the querysting. The problem here is that I cannot figure out how to refer to the name of the input field.
I have just finished building my first shopping cart in asp and MS Access. Originally the shopping cart was to be built for products with no size and colour, however as usual the goal posts have moved and I now need to incorporate a size and colour option for each product. Could anyone explain to me how I can go about doing this i.e. adding the different sizes and colours in the admin website and then linking them to a specific product when it is displayed on the products page? I know they both need to be in a dynamic drop down box when displayed on the products page within the shopping cart, but I am just wondering how to read the correct values out from the table depending on which product is being displayed. I have a normal products table at the moment with general fields i.e ID, name, description etc.
I have a web page hosted by server1. I need to add a link to a web page hosted by server2. This part is simple. However, I also need to give the linked web page the user id for the user that was validated in server1 (it's in a session variable).
At first, I thought the following would work: mywebpageonserver1.asp: Response.AddHeader "MYUSERID", "whatever" Response.Redirect "http://server2/mywebpageonserver2.asp"
i have a page that enters numbers stored in different values e.g monday tuesday wednesday thursday friday into a database. is it possible in asp to add those values up and store the added up value in a seperate field in the database bascially total =monday+tuesday+wednesday+thursday+friday How would i do that in asp.
I am using Dreamweaver MX to create ASP and MS SQL Server for database. I got a few fields like Value1 - Value5. So i have create the recordset of the 5 fields and i am extracting the total count of each field. Now i got 5 recordsets showing the total of each field. So is it possible to add the value of the 5 recordset together into one value? And is it possible to use the value of the recordset to do some simple math addition, subtraction, multiplication and division?
I need to add a ppicture to my Database.. The table is accessed through ASP Recordset but having troubles trying to insert an individual picture to each record?