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 RepliesHow to create multiple text fields and will be submit when press a "enter key" ...
View Replies View RelatedI have a search option on my website, which should perform a search on 4 fields, as follows:
tblNews
headline
content
tblDatabank
filename
description
It only needs to return matches which are an exact match of their search criteria. For instance, searching for "I am here" would return a record which contained "I am here", but not just "I" or "I am" etc.
I need to return all these records as part of one recordset preferably, as I want to be able to order them etc., though I imagine you may suggest I use an array somehow to merge two recordets etc., then reorder them?
I need to set up my front end app to update multiple fields with the same entry. See below.
Database: Testing
Columns:
Recdte
Invdte
So in this case, the user would need to update the Invdte with the current date for all rows where the Recdte is a given value. I know how to do this in SQL but not in ASP.
how to inner join multiple fields.
I have 1 table SCHEMA1 wich contains:
id|wedstrijd|speler1|speler2|speler3|speler4
1 1 1 2 3 4
2 2 2 1 4 3
The other table SPELERS contains
id|speler|naam
1 1 Jan
2 2 Piet
3 3 Klaas
4 4 Henk
I would like to have te next result:
wedstrijd|speler1|speler2|speler3|speler4
1 jan piet klaas henk
2 piet jan henk klaas
Can anybody help, because i'm lost......?
Is it possible to do an update on a recordset like this?display all the fields in a form and let the user pick which ones to update? What happens if they pick, say, two of the total to update, and leave the rest of the form fields blank? Would that update the chosen records and leave the rest of them blank or null?
View Replies View Relatedhow do i add afew items into a database of only a field name?
for example if there is only item_1.. it will add item_1 only. but if there is item_1 & item_2. how do i add them to the database name ("Items No")?
I have 4 number fields in the same table and need to display the lowest number from all 4 fields, is this possible?
View Replies View RelatedI have 4 tables first table category (category_id and category name in it)
second table artist (artist_id, category_id, artistname in it)
third table album (id, artist_id, album_title in it)
forth table song (id, album_id, title in it)
I'm selecting category in first page
I'm selecting artist in second page
I'm selecting album in third page
I'm requesting, collecting and posting all id's to the next page.
this is the question!!
How can I read from database
1- category name when I was selected in first page
2- artist name when I was selected in second page
3- album name when I was selected in third page
I've got 4 records in my lovely database table. The table contains 5 fields, lets say: id, number, name, age and sex. All I want to do is to get all the values (form all 4 records) of the "number" field and put all 4 of the values in to one variable.
The output have to look something like this : numbers: 001, 002, 003, 004.
I tired, honestly, I really did. But didn't find a solution.
I'm having trouble passing hidden fields between forms. I have a total of four forms. I have the 1st form passing its field to the 2nd form, and the 2nd form passing its field to the 3rd form, but the 1st form's field then is not passed into the 3rd form. So obviously, my summary form (the 4th form) is not getting the 1st form's field or the 2nd form's field, only the 3rd form's field. Code:
View Replies View RelatedI have multiple fields (BLM, WHM, RNG, MNK) each with a numeric value. How can I search across these fields for each record and find the highest number.
Example:
Name BLM WHM RNG MNK
----------------------------------
Jason 19 52 33 18
What I want it to do is return and display Jason WHM 52
And I want to do this for every record in the table.
I am using this script to submit my form fields into the body of my email:
***********************************************
Dim strBody
dim ix, formElementName, formElementValue
strBody = "Results of form submitted at " & Now() & vbCrLf & CrLf
For ix = 1 to Request.Form.Count
formElementName = Request.Form.Key(ix)
formElementValue = Request.Form.Item(ix)
strBody = strBody & (formElementName & ": " & formElementValue & vbCrLf)
Next
***********************************************
I'm completely new to vbscript and have been searching all over the net for an example of this script being used with mutliple fields with absolutely no luck.
The closest I've come to getting something back from this thing is when I tested the script with these elements:
FormElementName = Request.Form.Key("Name")
formElementValue = Request.Form.Item("Name")
formElementName = Request.Form.Key("Telephone")
formElementValue = Request.Form.Item("Telephone")
formElementName = Request.Form.Key("Email")
formElementValue = Request.Form.Item("Email")
Which produced this result:
Email: Email
Email: Email
Email: Email
Its seems the answer to my problem lies in defining the 'Key' and possibly the 'Item' parameters but I haven't been able to find any documentation on these terms. Can someone out there please save me from what probably is a very simple solution?
I have a form on one page where someone selects a bunch of options and details about a specific category. Then on the next page they fill out a form with contact information, name, address, email, etc.
Well what I want to know is when they click Submit on that contact form is there a way to have it so it goes through and searches the database for any that match the state and county(which they will select from a )??
So what I basically want right now is for the first form to be filled out, then the second form to be filled out, then when they are submitted it will go through the database and select everyone in there with that state and county, then on the next page display the results of both forms AND the matches in the db(obviously whatever fields I want it to display).
I already have both forms(basic html), I already have the dynamic dropdown for state and county(classic asp), what Im wondering is how do I put that dynamic dropdown in the contact form and then when submitted it will go through and search the db based on what was selected there. Would this be some sort of onClick for the submit button tellin it to search the db based on the dropdown or how would I get started on something like this?
There will be other information on the dropdown like name address email so one problem I was wondering about was my dropdown menu. When you select the state it refreshes the page and then loads the counties, so wouldnt that erase anything that was filled out on the form?
I could make it so they actually type the name of their state and county but that causes problems too because if they mispell either then it wont return any results.
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?
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 RelatedUsing 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?
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
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.
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.
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 Relatedi 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 RelatedI 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.
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!
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?
I have been trying to populate multiple email addresses in a textbox like in Hotmail.
My aim is to send a mail to multiple recepients at the same time.
I want to populate all addresses to "TO :" section.
The problem I face is that I was not able to write multiple email addresses near by near
For example
xxx@yyy.com; eee@www.com
I can only populate adresses one by one in a text box
You can find my code which works but not in a way I want. Code:
The user can search the database when they put in a date, that works fine, but when i put in another text box to search the database for a certain date range Code:
View Replies View RelatedIm new to ASP.NET as well as classical asp. To become strong in .NET, should i learn vb verywell (because im relatively new to it but it doesnt look that foreign working with vbscript) or the .net framework such as classes and server controls?
View Replies View RelatedI am wondering if any body can guide me on how to break up a string so that i can use the first letter as a querystring.
View Replies View RelatedI need to break out of the frames in the following line, or a line that does a similar thing:
Response.Write("<meta http-equiv=""Refresh"" content=""2; URL=http://localhost/MyWeb/Loanerz.asp"">")
How can i break out from a while loop or for loop in vbscript.
in jscript we can use break etc..
in vbscript how can i do it. can i go to statment.
I have a string of text which I have managed to seperate with commas
e.g. test,test1,test2,test3,test4
if anyone knew how to split this up into individual words. so i can write them to a databse.I have been stuck on this.
I am trying to merge 2 strings together from the database to create a meta tag. It comes up as
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="description" content="Looking for Architects in NY? Click here for Architects in New York."><meta name="keywords" content="architect, local, builders, home design, remodelling, construction, Albany County, Albany, Colonie, Saratoga County, Rensselaer County, Troy, Schenectady County, Schenectady, Montgomery County
">
It works fine, however the the last "> breaks off to the next line which shouldn't be happening. I tried searching for "<br>" and chr(34) (the carriage return),but there's nothing.