Allow Multiple Integers In A Field
How can I allow entering multiple integers in a field? examples: 11, 13, 15 or 11-16 or 11-16 step 2?
View Replies
ADVERTISEMENT
Multiple Values In One Field
how do i insert multiple values into one database fields using ASP.
View Replies View RelatedMultiple Field Search
how to search multiple fields in an access database?Basically I want the code to search an entire table, field irrelevant.While I'm at it, does anyone know how to make the same search not care about word order or placement?
Such as:
Search string: "John went to the store"
returns the same results as
Search string: "The store went to John"
Just thought I would throw these out there and see what direction anyone can lead me.
Stuck On Update Multiple Records (same Field)
how to update a database from a dynamic table with checkbox. Their is only one field I would like to change and that is the one with the checkbox.
I am using Dreamweaver and I create a dynamic table, add the update record and I get BOF EOF error. The database does have data in it. Code:
Multiple Field Form For This ASP Mailer Script
How do I convert this ASP mailer script to accept and mail multiple fields of a form. This will do one field only )iMesg.TextBody = Request.Form("body") and it works great. Code:
View Replies View RelatedPost Multiple Values For One Form Field
I loop through a recordset to return values that populate a form which
the user can then edit and save. However these fields need to be validated first
to make sure the data entered is correct. I have a Firstname field that returns 3 records
from my recordset which means when I try to validate, I get an error as the page doesn't know which of
the 3 to use. I believe I have to do it through an array, but have no clue how as my efforts have failed
Freeaspupload: Retrieving Multiple Values From A Select Field
I'm having problems retrieving all the values from a multiple selection field using the freeaspupload component.
I'm creating an online email app that uses the freeaspupload to add attachement functionality, which means the form encoding type is multipart/form-data. I've done something similar with the persits aspupload component, and had no problems with that, but the freeaspupload version seems to handle <select> fields slightly differently. Code:
String On Integers
To put a string on integers togther.
Not like strNumbers = "1,2,3,4"
But like:
strNumbers = 1, 2, 3
so that it can be actually treated like intergers instead of just a string.
Limitations Of Integers
i need to use bigger numbers that integer allows in asp. what should i use? i still need the whole number quality of the integer, but when i use anything larger than about ,100,000,000 i get the error Overflow: '[number: xxxxxxxxxxx]'
with the x's being the number i used. anyway around this?
Adding Integers In Arrays?
I have two arrays that contain integers and I would like to add them, say array1(0)=1 and array2(0)=1. If I just do something like array1(0) = array1(0) + array2(0) I end up getting 11. How can I make it add the appropriate integers?
View Replies View RelatedSorting Integers In An Array
I have an array, PositionArray(), which contains a variable number of integers. I need to sort these array elements numerically. Seems I've done this before in VB, but I can't seem to get my mind around it now. Does anyone have a simple bubble-sort code, or is there an ASP way to do this?
My ultimate goal is to take a chunk of text, and highlight (bold, color, whatever) words that are contained in a string array. My thought is to find the position of each word with the InStr() function, then find out which position occurs 1st, which position occurs 2nd, etc., then build a string from the beginning of the text chunk to the position where the first word begins, add a bold tag, add the word, add a </B> tag, and continue until the end of the chunk.
Problem When Multiplying Integers
I need to multiply a price by a quantity. I'm using the following:
intTotal = (int(strPrice) * int(strQuantity))
strPrice contains the value 20.80 and strQuantity contains the value 10
It gives me a total of $200 when it should be $208. Why does it discard the .80 cents in the multiplication? What can I do to fix it?
Making An Array Of Strings Out Of Integers
I'm trying to make an array of strings to compare to. Each string will be made up of 3 different 4 digit codes with spaces in between each code (ie "1001 2003 3001").
I'm currently using this code to do this but when I write the string out to the screen I only get the <br>. Code:
Compare Two Integers Type Mismatch Error
I am getting the error below when I am trying to compare two integers.
strbid = rstB("BID")
bid = rscon("BID")
I am getting the values of strbid and bid from two seperate queries.
if (strbid <> bid) then
Microsoft VBScript runtime error '800a000d'
Type mismatch
I know both the fields are of same data type in the database. I am using SQL Server.
Am I doing anything wrong while comparing?
Update/Query Problem - ASP Reads In All Integers As 0
I have developed this script that is meant to take in a value from a database record add one to it and post the new number in the record. It works ok but it always seems to read all database records as 0 never as thier true number (i have tried it set to 1,2,3 etc)
Code:
Array Integers Vs Array Variables
In working with arrays, I have found that I am unable to dimension and array
with a variable that has an integer value but I can redimension one this
way. I haven't see any information that tells me if this is a requirement,
although it appears to be because I get an error if I try it.
Ex.
Dim b
b = 10
Dim a(b) ' this errors out but
Dim a() ' this
Redim a(b) ' works
Code:
LEFT JOIN On A Date Field And A Numerical Field - Using WHERE Clause
I am using a Relational database for my site and i have the following tables:
FIXTURES, GAMEDATES
the fields in FIXTURES are:
GameDate
Home
Away
(All of the above are numerical fields)
the fields in GAMEDATES are:
DateID(integer)
GameDate(#Date Field#)
What i have done is in the GAMEDATE field in the FIXTURES table i have used the ID number of the date that i wish to assign to that record - using a LEFT JOIN to display the actual date that is pulled from the GAMEDATES table (That which corresponds to the relevant id used in Fixtures)
The problem is that in some of my code i want to display records using sql and sometimes in the where clause i use the following:
WHERE Fixtures.GameDate<=(Date())
obviously meaning WHERE GAMEDATE is LESS THAN or EQUAL to TODAY.
The thing is when i use the join it does not use the where clause and displays all of the records in the FIXTURES table.
Does any one know how to get around this, i have not received any error messages it just isnt displaying the right data
SQL Server - Update/Insert Multiple Cols Into Multiple Tables
Just as the title says I am trying to do something impossible with a single SQL statement. I am doing an ASP webpage for internal use at the company I work for.
I want to know if there is a way to insert/update data into multiple tables in 1 SQL statement.
If it requires functions | views or anything else that is fine but I don't want to have 3-4 different SQL statements to update 2-3 different columns in different tables.
Searching Multiple Memo Fields In Multiple Tables In Access
I 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?
Comparing Field Data From Previous Field
Im comparing values in a field while doing a loop if sAct<>myData(5,i) then At the end of the loop I make the value of sAct equal the current myData
This will work when comparing other fields withing my recordset (so I know the statement works) but it will not work for the field I want to compare. The only difference with this field is that it has null values. Could this be the problem? if so, how do I deal with nulls?
Fill Field Based On Another Field
I have a input form with 5 fields. One of the fields is MajorNo and the other is named Description.
I have a reference table in my MS Access database (tblMajor)that lists the major numbers and their descriptions.
I would like to have the description field in my ASP automatically filled based on the major number entered on the form, so the user will only need to input the major number when submitting to the Access table (tblSalesTotal).
How To Update Multiple Records With Different Multiple Value
i hav problem with updating the data. In the asp page i hav displayed records based on search criteria. in display mode im displaying the to be updated field in combo box for each similar contract_no. each contract_no will hav different no of rows and to be updated combo box.
based on the selected value in the combo boxes of different contract_nos i hav to update the combo value with old value. user select multiple combo values at a time I need anybody's help with detailed programming logic.
Pass Hidden Form Field Value To Another Form Field To Insert In Db
I am trying to pass a hidden field value on a form into another field on the
form so that it can then be inserted in the database, to enable me then to
reference that number at a later date.
(The hidden value (1 for example) would then automatically get passed to the
other input field.)
The code for the text field that allows users to type an number into it for
submission to the db is below, but what code do i need within the hidden
field to populate this text field below so that users do not have to type the
number in? Code:
How Can I Change One Line Input Field Into Larger Input Field
I have being working with making an edit field over the past few days. The edit function is now working fine. The edit fields that i have are for id, subject, notes, timedate.
All of the edit screens are one line text screens. What I want to do now is increase the size of the notes box to a larger textarea type box to make it easier to edit notes. The notes field in the db is a textarea field. Code:
Automated "state" Field From "Country" Field
When you select the "Country" field in a Hotmail "get new account" link, the field "State" changes automatically, giving you the correct States that belongs to the chosen Country.
View Replies View RelatedRequest.Form("Field Name") Versus Request.QueryString("Field Name")
I want to know what's the differences between
Request.Form("Field Name") and
Request.QueryString("Field Name")
OR they function exactly the same, which is to return the value of the
field??
Field Value
I would like to capture an entered value and use it in a query (Access)
Part No. __________
Do I need to store it in a variable and then can I have the query come up on the same page - they would enter a value and click a submit button. I'm not sure that I am on the right path. I'm not sure what syntax to use. Code:
DB Field
What is the correct code to use to hide a section if a specific DB field is
NULL.
Bit Field
I'm trying to select all records that are true.
Code:
activerecord = -1
strsql = "select cnum from [topline data] where cnum = '" & cnum & "' and activerecord = '"& activerecord & "'"
is that right?i get this error when it equals 0. Microsoft OLE DB Provider for SQL Server error '80040e07'
Db Field
Using asp and mysql, can a text field in the db have a record with asp code in it and then display correctly on an asp page?
My experience is that it does not show anything in the <% %> tags but it shows the asp code when you view source. My coworker wants to make our website database driven and this text field was going to be the page content with html and <% if then else %> statements.
This does not work with php either so is there another field type that will parse server side scripting?
DB Field Contains XML
In our ticketing system database, some fields may possible contain XML. To display a field for example, I have always used: Code:
<%=(rs_tkts.Fields.Item("CloseDesc").Value)%>
but this does not display the xml code listed. what I should do?
Add Field
Im wondering if there is any way to add a field into an MS access Table using SQL/ASP..
The reason im asking is my database online is Access 2000 (which i have at home), and im in work and they use Access 97.. so i cant download the database, add an extra field into the table, and then re-upload..
Ive tried using a Make Table, Update, Append.. but it doesnt like any of them statements..
Multiple SQL's
I have a database being updated by a text file every ten minutes, so in the code that is why the column names are messed up.
My problem is I get all the sums, and counts all working. What I need to do is at the end of it have a sum for for all the columns returned, i.e. col002, I need all the sums in that column added up for a total at the bottom. The following code works but when I try to do column totals I can't get it to work, Code: