How can I figure out an database field maximum size with asp?
Currently the form I am using allows to write too long strings and it corrupts the database of mine. How can I set the limits to be calculated from the database structure?
I'm creating a database site and using access. I've created a number of
fields i.e date, time, description, cost
The only problem is that the description info is larger than the 255
character limit imposed by access. How can I solve this one?
Why the instruction runs ok on sql server 2000 but in access 2000 brings me the maximum size of field in the table:
SQLCategoria = "Select * from Biblioteca_Categoria where Len(Codigo) = 6 order by Codigo asc"
HOw can I prevent my users from entering more the a certain number of characters into a field? Could I get a similar example as I have a limitted knowdlege.
View Replies View RelatedI want to create some text input fields which they should all have the same size regardless the browser version or type. Because my text input field looks different in size if I view them from a different computer. Is the following coding should solve the problem?
<input type="text" name="field" value="" size="30" style="width:300px;">
Is the best way to use CSS to control the size of a text input field?
I am developing guestbook using ASP and access. problem is access fields holds max 255 characters. Is there anyway I can create 2 message fields so when first one is full it uses second field. Apart from above any other ideas will be useful. Do you think it's good idea to use notepad to store msgs.
View Replies View RelatedI have an access database with year designations for field names, such 2005 2004 2003 ... and data corresponding thereto. I can formulate a query in MSAccess and it works just fine. However, I am trying to create a web page that will create a database
connection and use SQL to create a recordset(s) which I can then manipulate in vbScript.
The problem seems to be structuring a query that will work in
vbScript. I have tried several combinations:
rs2.Open "SELECT 2005,2004,2003 FROM Table", conn, adOpenStatic, adLockOptimistic
rs2.Open "SELECT '2005','2004','2003' FROM Table", conn, adOpenStatic, adLockOptimistic
rs2.Open "SELECT "2005","2004","2003" FROM Table", conn, adOpenStatic, adLockOptimistic
but none of these will extract data.
I have also tried casting these numbers to strings in a string variable, but still no success.
Is there some naming convention I am violating by simply using year designations as field names or is there a problem with vbScript?
I´m using a code reload a page. Can I use the following code Code:
strSQL = "UPDATE chattare SET dteOnLineTimer=#"& Now() &"# WHERE chattNamn='"& strUser &"';"
to update the field " dteOnlineTimer" with Now() each time the page is reloaded?
I'm using Windows 2000 server n IIS I'm Using FileSystemObject of ASP in Server Every File and Folder has 2 Size when we get properties of any 1 actual size and Size on Disk.now my problem is when i get the file size from ASP object it give Size value but when i try to get folder size it gives size on disk and both values are different.
I'm creating a size to access limited size to upload files so i just check the folder size and then get size for those which are going to update by user then i will less those size to actual folder size to get remaining size.
I can't print the contents of an Access memo field. Every other field type displays fine but this one.
I saw an old thread saying that you should first assign the memo field to a variable but that also doesn't seem to work (please see the attached bit of code). The memo field is "Message". Code:
I have more than one date field on my ASP forms (and in the sister MS Access table) I can not write (created the record in Access table) to the table UNLESS there is date data in ALL the date fields on the ASP form.
I need to be able to have the user enter only one date, then do back at a later time and enter the other date.I am using the short date format in Access table (MM/DD/YYYY) When there is only one date field (on ASP form and in Access table) the date is written and the record is created.
I have a timesheet application I'm working on. The user fills in a form which sends data to an Access db. On the results page I need to display the values from 2 fields; i.e if the user selects "Report Writing" from a drop down list, I need the data contained in another column called 'Codes' to display as well.
View Replies View RelatedI am pulling legislation information and expiry dates from an access database and posting to the web. The expiry dates in access are formatted as Month Day, Year (EG.. January 1, 2006) But when they are pulled from the database to the web, they come out as 01/01/06. I know that the format we have in access is simply a mask, however we require that format be carried through.
This is likely a simple solution, however I am new to ASP and can't seem to locate any information on this. I have searched the forum for related info on this but can't find anything that relates to my specific situation.
Here's the code we are using so far...
Code:
<%
Do While NOT Recordset.Eof 'i.e. carry on looping through while there are records
Response.write "<tr><td>"'open row and first cell
Response.write Recordset("Legislation")
Response.write "</td>"'close first cell
Response.write "<td>"'open second cell
Response.write Recordset("Repealed")
Response.write " "
Response.write Recordset("Expiry_Date")
Response.write "</td></tr>" 'close row
Recordset.MoveNext 'move on to the next record
Loop
%>
I have also found and implemented the following code:
Code:
dt=recordset("Expiry_date")
dt=Month(dt)&"/"&day(dt)&"/"&year(dt)
response.write(dt)
This lets me change the positions of the numbers, but I can't figure out how to make it display the full month name and full year.
I have a DateTime stamp in one of my Access database columns. Using now() as the default value, it enters records in the following format:
17/06/2005 14:28:40
This is perfect. UK format, just as I want.
However, when I pull this record into an ASP page it appears in a different format:
6/17/2005 14:28:40 AM
How can I stop it from re-writing the data into American format? I just need to display it exactly as it is in the database.
As part of a data input script, I ask for a user name to be input into an Access DB field called surprisingly, "UserName". I would like to ensure that username is not duplicated. How do I do that before inserting the data. My example show in the incomplete script below doesn't work? Code:
View Replies View RelatedLooking to populate an access db table 'ole object' field through asp code.
View Replies View Relatedi have a checkbox Code:
<input class="txtbox" type="checkbox" name="C1" value="ON">
it will correspond to a field in my ms access database that has a Yes/No data type. when the box is ticked, i would simply like the value Yes to be entered into the database..
i enter other elements of my form (a input text box for example) using Code:
rsAddComments.Fields("area") = Request.Form("area")
so what would the entry code look like similar to this.. and what would the for checkbox code look like?
I am planning to migrate my exisiting MS Access program that uses yes/no
fields (checkbox). Can ASP identifies checkbox field of ms access? I am
planning to use the same database and use msacess for report generation and
web browser for encoding to the database.
I have been doing adodb connections and using Access2000 for several lightweight websites. I have never had any problem with any of the SQL commands to insert, update, delete, etc.
I can insert a record into a memo field just fine ... up to a certain number of characters (nowhere near the 65K limit). After several hundred characters, the insert fails ... nothing happens ... the execute just idles and no insert is done. Anyone help? I have read about data types, etc., but everything I read sounds as if ASP and Access 2000 are suppose to handle the type conversions. They have been doing it up to this certain size.
I have a request form that is used for requesting copies og an edition of a magazine. What I need to do is get back the information, from a MS Access table, for the issuedate and deadline.
Because the deadline is not always the same number of days (ie dependant on issue it could be 14 days before, or 21 days before etc), so as well as picking the issue date from the table, I need to be able to get the deadline date back, and write to a seperate Request "field" on the Form. Code:
I'm using asp to retrieve data from a server and import that data in a client that uses MSAccess, into a memo field. The text hes line breaks 0D 0A (the usual DOS line breaks). However the client sees these line breaks as two squares!
The strange thing is that when I look at the exported text (yes, I also export text from the client to the server), it also contains the same line breaks. So the exported text from the memo field can look exactly the same as the imported text, and before the export the line breaks are correctly shown als line breaks, but after the import that same line breaks are shown as squares! I would like to see line breaks after the import and NO squares.
I have a text field in a web page I am working on that seems to be calculating phone numbers before inserting them into an Access database. i.e., 867-5309 will result as -4442 in the Access text field. My guess is that the webserver or client is processing it before inserting it. Is there any way to stop this other than using a validation script?
View Replies View RelatedI 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
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?
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 can I get size a file from any sites.
http://www.domain.com/fileblablabla.zip
I want to know what the size of file is by using ASP..
is there any way ?
or is there any free component ?
(But it must cancel immediatily after getting the size of file..
because maybe its size can be 50 Mb
I am using variable passing through the url, and as it is getting larger, I am finding that occassionally some values are getting trimmed. Is there a limit to how long a url can be?
View Replies View Relatedhow can I get different font size in the form method "select", "input"
instructions working under ASP? because when I check with the browser is too
big in the table.
============================================
<FORM method="post" action="../gallery/default.asp">
Select a category:
<SELECT name=""CategoryID">
<option" value="">Select Your Gallery</option>
<OPTION value="3">Digital Package</OPTION>
<OPTION value="6">others</OPTION>
<OPTION value="5">test</OPTION>
<OPTION value="4">Traditional Package</OPTION>
</SELECT>
<INPUT type="Submit" value="View Photos">
</FORM>
==========================================
I am having a problem with this code. The problem I am facing is that
the first image is displayed in its original size. But when I click the
next button, the next image not displayed in its original size, but
being displayed as 100 x 100 pixels, same goes to the 3rd picture and so
on. Code:
cookie has a limit size? if yes, how big?
View Replies View RelatedI only need to know the height and width of the image.
It doesn't seem to be as easy as php's "getimagesize($imgFile);" method.
<%
'Copyright *c* MM, Mike Shaffer
'ALL RIGHTS RESERVED WORLDWIDE
'Permission is granted to use this code
'in your projects, as long as this blah
'copyright notice is included
function GetBytes(flnm, offset, bytes)
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objFTemp = objFSO.GetFile(flnm)
lngSize = objFTemp.Size
set objFTemp = nothing
Set objTextStream = objFSO.OpenTextFile(flnm,1)
strBuff = objTextStream.Read(offset - 1)
GetBytes = objTextStream.Read(bytes)
objTextStream.Close
set objTextStream = nothing
set objFSO = nothing
end function
function lngConvert(strTemp)
lngConvert = clng(asc(left(strTemp, 1)) + ((asc(right(strTemp, 1)) * 256)))
end function
function lngConvert2(strTemp)
lngConvert2 = clng(asc(right(strTemp, 1)) + ((asc(left(strTemp, 1)) * 256)))
end function
function gfxSpex(flnm, width, height)
fileT=split(flnm,".")
if fileT(1)="gif" then
Width = lngConvert(GetBytes(flnm, 7, 2))
Height = lngConvert(GetBytes(flnm, 9, 2))
elseif fileT(1)="bmp" then
Width = lngConvert(GetBytes(flnm, 19, 2))
Height = lngConvert(GetBytes(flnm, 23, 2))
elseif fileT(1)="png" then
Width = lngConvert2(GetBytes(flnm, 19, 2))
Height = lngConvert2(GetBytes(flnm, 23, 2))
end if
gfxSpex=true
end function
if gfxSpex("images/urlogo.gif", w, h) = true then
response.write w & " x " & h
end if
%>
Which is a little bit shorter, and seems to work ok so far, but isn't there anything easier, like php's "getimagesize($imgFile);"?
I have a drop-down with 40 option values and only one option should be selected of the 40 options. The list size should be 1.
When I click on the list, it drops down 30 options (a very long list) with a scrollbar for the last 10 options.
Is there any way, when I click on the list it drops down only 5 options (as if the list is of size 5) and allow a scrollbar to browse the remaining 35 options.
Code is:
<select name="deplist" id="deplist"
<option value="Commerce">Commerce</option>
<option value="Instru">Instrumentation</option>
... similar such 38 options
</select>
I need to set the image size in the following line. When I try to set the
img to 75x75 I am getting an error. The line I'm having problems with is :
Response.Write "<a href='" & imageFilePath & strPicArray(0,x) & "'><img
src='" & thumbFilePath & strPicArray(0,x) & "'width="75" height="75"></a>"