Converting Text Fields

Using ASP,VB Script,Access 2000. I have a macro which imports Fox Pro 2.6 databases into Access on a daily basis and then these tables are uploaded to the website.

When the tables are imported the fields which store numerical values with 2 decimal places are converted to text fields and it drops any zeros after the decimal point (e.g 124.40 becomes 124.4 and 110.00 becomes 100).

I am querying these new tables in my ASP pages but I want to convert these text fields back into numerical values with two decimal places. This is so that product price list on my page is all formatted the same. Is there a function I can use in my SQL statement to achieve this, or will I have to run a macro which re-designs the tables before I upload them to my website?

View Replies


ADVERTISEMENT

Converting Fields

I am trying to get values from our database which are in a single field, into seperate variables.

I have a field called locations, with multiple values example... "East Sussex, London & Home Counties, Scotland"

I would like to get each of these into seperate variables e.g.

variable 1 = East Sussex
variable 2 = London & Home Counties
variable 3 = Scotland.

I guess it will need some sort of regex to detect number of commas, then a loop or something.

To make things slightly easier, none of the values in the locations field have commas inside them.

View Replies View Related

Optional Fields In A Form, Converting To ASP And SQL

I am trying to incorporate a search feature, and I am having problems thinking up some code to accomplish a certain thing: I have a page that allows a user to search for Industry-specific locations.

It is a basic form with City, State, Zip, radius fields. I also want to incorporate optional fields, such as the different types of amenities/facilities that the building offers. These amenities/facilities will have checkboxes. Code:

View Replies View Related

Converting Text To Js-asp Code

I have a site which uses javascript in an asp document to draw the content
for part of the site from an external .js file.

I want to be able to have a web interface where i can input text, and
convert then save the file to the *.js format. This would involve adding
"document.writeln(' "to the start of each line, and " ');" to the end. This
would also involve adding <!-- to the start of the whole thing, and //--> to
the end.

Would this be possible, and if so how would I go about doing it, are there
any scripts out there that I have missed, or is there a simple way to do it
manually?

View Replies View Related

Splitting Text Fields

I am about to show a text field from SQL7.0 database, but need to display x number of images spread out amongst the text!! Basically similar to how bbc.co.uk/news display news articles....

I am wondering the best way to do this...

I was considering splitting the text into variables and then to display these sections next to the images.

Anyone else done this?

View Replies View Related

Disabling Text Fields

i have a form that has a multiple fields,when a user chooses an option from option seleect then it should disable some part of the form and i have no idea how to do that.

View Replies View Related

Numbers And Text Fields

I have a form where you input year (number) and a Ref (number) and a section (char) and then submit to output a record, i added an if with a messageto prevent the eof and bof , and it is working if i inputed wrong numbers, but if i input text in the year or the ref, he will give the following message, how to prevent users from entering text into numbers fields, because in the database they are numbers, or what else could i do.

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
/iri_site/Importer/auth.asp, line 27

View Replies View Related

Single Quotes In Text Fields

I have an events calendar on my site, allowing local people to post events there. Two problems have come up:1. In the details section, people will naturally want to include apostrophes (single quotes) from time to time. This fails, because VBScript sees them as delimiters. Is there any form of quote marks I can use to make sure this doesn't happen?

2. The same field is defined in the Access db as Memo, which normally gives up to 64K of text, as opposed to Text, which only allows 255. Despite this, text over 255 is ignored, leading to the text being truncated.

View Replies View Related

How To Create Multiple Text Fields

How to create multiple text fields and will be submit when press a "enter key" ...

View Replies View Related

Hide/Show Text Fields

I have a form that has a drop-down select box which is linked to a database table, and also tow text fields. I would like to show or hide text fields according to the value selected in the select-box without refreshing the page.

If I select TEST from the select box I want to show the RESULT field and hide OTHER field . If I select anything else I want to show the OTHER field and hide RESULT field. I'm interesting code in ASP and PHP.

View Replies View Related

Form Submission With Same Text Fields

I have 3 fields in my form and one of them called ID with multiple text fields e.g (there are 10 text fields for ID) and when you submit the form all the 10 ID's should be submitted to the DB for that particular record with a single space inbetween the 10 ID's. Can any one tell me how this is possible.

View Replies View Related

Breaking Text Up Over Multiple Fields

Is there any way that I can break up text in a text field to spread across multiple fields in an access database? I've got a FAQ section that I want admins to be able to edit via an online interface. Unfortunately, it often doesn't fit into the 255 character restriction that access has. Any ideas?

View Replies View Related

Form Including File And Text Fields

i want create a form that include many text boxes and an fiel field for upload a file to server but when i add "enctype="multipart/form-data" in the form tag i cant get the texts . how can i do a form working with file upload and text fields.

View Replies View Related

Binding 2 Text Fields On An Online Form

I am trying to bind/link 2 text fields on my online form.

So they both should show the exact same text entered in them.

When text is entered in one of them I want to see it in the other text box and vice versa and when text is deleted from one of the boxes it should also be deleted from the other one aswell.

View Replies View Related

Populating Text Fields Based On Drop Down Box Selection

I am working on a small application for senior users, so I want to limit the option for incorrect input whatsoever. I have a drop down box that is populated from a query and I want to make it so that when an option is selected, the pertinent text fields are populated based on the selection.

All the info I need is already being extracted from the query so its just a matter of displaying the right info based on the selection. I have been looking for examples of code but they all seem to use javascript. I am not too strong in javascript so I kinda avoided those. if there is a pure asp example, that would be fine!

View Replies View Related

Accessing Text Or Large Varchar Fields In SQL Server

I have read that there can be a periodic problem when reading large varchar or text fields from SQL server (or memo fields from Access)--they can sometimes come up as empty strings.

What I have been unable to find out is whether this problem is still around in recent versions of MDAC (>= 2.8). Does anyone know whether this problem still occurs--is it still necessary to follow the steps in that aspfaq article?

View Replies View Related

Converting An Image File To Hexa, Read Text File

i'm converting an image file to hexa..then the hexa is saved to a text file..

can any one help me how to read the content text of a text file?...

im doing it this way because i don't want to save hexa in my database, because it makes the database slower to open up.

View Replies View Related

Converting Text File To Sound File In ASP

Does anyone know of a method of converting text files to sound files (.wav, mp3 etc) which can be accessed from ASP?

I have an ASP-based website that enables users to design choreography for equestrian dressage. The resulting design is held as a series of coded movements in a database and it can then be reproduced as text or as a series of diagrams. I would like to offer the option of an audio version.

View Replies View Related

Converting Text File To .iff File (VB,ASP)

Does anyone have knowledge of converting text file to .iff file. I am working on a VB ASP application. I searched for example on internet but I didn't get anything.

If you have any idea of converting text file to .iff file (VB ASP) please share with me.

View Replies View Related

Converting Hrs And Min To Just Min

I am using two fields on a form to capture time someboby is working. The fields are hours and minutes. How can I when submitting to the db take both fields and convert them to a single field in the db as minutes?

View Replies View Related

Converting PDF To DOC

I'm looking for a control to us on our web site that will take our reports
that are generated in PDF and convert them to DOC format all on the server.
We are using win2k3 web servers if that helps.

View Replies View Related

Converting VBA To ASP

I have developed an access database with VBA. Right now its on a network drive and is shared by 75 users. Works fine.

Now I would like to have this in the company intranet. Is it advisable to go with ASP? I recently installed IIS in my system. After that I have no idea how to convert my application to ? Is there a website or any walk through how to get my stuff's solved.

My application has 20 input screens, data add, save, update and also sends email based on certain rules. Is it possible to do all these stuffs?

View Replies View Related

Converting CSV To XLS In ASP

I want to convert CSV file to XLS. Is there anyway this can be done in ASP without renaming the file to XLS.Also can there Macros to Sort data in it while generating XLS?

View Replies View Related

Converting Cgi To ASP 3

We are evaluating a clients request for converting their existing site using cgi and flat text files to ASP 3 and Access.

The site displays: their products that are broken down into sub categories, guest book, and a survey.

I am only "aware" that text files can be imported into Access but have never done it.

View Replies View Related

Converting PHP To ASP

I have some PHP scripts that need to be converted to ASP3 so that they can run on a Micrsoft NT server using ADO. My knowledge of ASP is limitied so i was hoping you could answer a few questions..

1. Is ADO part of ASP.net or is this completely different?
2. Is ASP3 the same as ASP.net?
3. Is there any advice you can give me regarding converting from PHP to ASP3?

View Replies View Related

Converting

I've stored a set of months in an access database as numbers but when it display on the front end I need it to display as the name of the month.

How would you convert the numbers in the database to their word equivalent? Or is it possible to arrange the months in their correct order in the database?

View Replies View Related

Converting To ASP.net

I have an existing application in asp. I need to add new functionality can I do using ASP.net ?

View Replies View Related

Controlling Text In A Text Area Or Text

I have this problem in controlling a the text in a Text Area. How can I do
that for example the field size is 200, when it reaches 50 it automatically
goes to the next line. Bcoz im having problem when viewing it in my report,
it continuesly views in a strieght line and im having problem in printing.

View Replies View Related

Converting US Time To IST

Do we have any function in ASP that will convert US time(which is captured in the database) to IST

View Replies View Related

Converting Int To Varchar

My data input page uses a id generator which includes dashes, and the
corresponding column in the db is set up as varchar to handle that.
There is a problem, however, when the value in the varchar column is
compared to the string from the URL, and the following error message
occurs:

"Syntax error converting the varchar value '071-213' to a column of
data type int."

<%strSQL = "SELECT * FROM AMS where MinutesID = " & Request ("id")%>

Would it be possible to CAST the request string to varchar?

View Replies View Related

Converting String => Int

I am passing a string into a page and them looking up info to display from a database based on whats passed in. The link is www.domain.com/page.asp?variable='12345678'
Once inside the page the following code is executed Code:

View Replies View Related

Converting To Excel

i want to convert asp file to excel sheet through asp application. iam having report.asp file as a view form i need that form to convert in excel sheet can you help me.

View Replies View Related

Converting Sql Statements

I have a project to do that requires that I use mysql as the database. I have only used MS Access. The sql will be simple searches.
Is there a drastic difference, or just different punctuation?
Can I find a copy of mysql on the web? If so, is there any advice on installing?

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved