Retrieving Field Properties
How can I retrieve the default value and allowzerolength property of all the fields in my table? I'm using ADO.
View Replies
ADVERTISEMENT
Retrieving Url Properties
Is there a way in asp to retrieve part of the URL and use it
say the url was
http://localhost/site/craig
is there anyway of retrieving the word craig so to use it in the page
This is because i could have other addresses that are for example
http://localhost/site/Jon
where i need to retrieve the word jon
Retrieving Properties
How to retrieve "Last modified" & "FileName" from all files in a specific folder (called MyDocs) and display on the ASP page?
eg. (in MyDocs folder)
- MikesWork.doc
- MyResume.xls
- HouseExpenses.xls
Situation
Let's assume that i just modified MyResume.xls file and save it today(10/30/2003) on my computer, then i upload it into the internet. On my asp page, i want to show all files Filename (Last Modified) in MyDocs folder.
eg.
Your Documents
1. MikesWork.doc (last modified 10/24/2003)
2. MyResume.xls (last modified 10/30/2003)
3. HouseExpenses.xls (last modified 9/15/2003)
I know it has to do with fso or something close to it... but totally have no idea (zero) of its logic or how it works. Please help me by giving me with full example.
Field Properties
Can anyone help with the following:
I wrote an ASP script with allows me to select an MS Access database
from a folder, and it shows the tables in this database. If I click a
table, the fields are displayed. And then I have a button to create a
HTML form to suit this table.
My problem is, fields that are essential.I would like to mark
appropriate form fields as 'essential' . Is there any way I can get the
attributes of a field, so I know if it will accept null values?
Retrieving Date Field
I am trying to retrieve a date field this is the code
strQ ="SELECT * FROM WaterCompanies ORDER BY WaterCompany"
set objRS=objConn.Execute(strQ)
This is where I am using the date
Response.Write "<TD>"
Reponse.Write objRS("JoinDate")
Response.Write "</TD></TR>"
all the other fields populate so I know I have a good connection.
this is the error
Microsoft VBScript runtime error '800a01a8'
Object required: '' /waterbilling.asp, line 76 <--- this is the response.write objRS("JoinDate") line
Retrieving Field Default Value
I have 3 text fields in an Access db with each some default values.
I have an edit page where user's can edit those fields. The problem am having is if for instance I empty the field in the edition page, since am not allowing null or empty in them, when I save of course I receive an error telling me that this field is not allowing empty value.
Now what I would like to be able to do is this, when I save I'll check If the request.form("thefield") is empty, if so then instead of saving the empty value I want to return to the default value set in the db.
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:
Image Properties: How To Get,
I am wondering if it is possible to get more information on files then just
name, date, size etc..
Specific, I want to know what dimension (x and y pixels) an images has.
Can this be done by ASP. Do I need a component? Are there free components
out there?
Object Properties
Is there any way to list all the properties that an object has? For example if I do a CDO.Message object and call it NewMail. Is there anyway I can find the properties of that the object supports. IE NewMail.From, NewMail.To etc
View Replies View RelatedFile Properties
I want to ask are there any other ways to get the file properties such as file name, path, date created... other than using 1. FileSystemObject or 2. file upload with encType="multipart/form-data".
For FileSystemObject, I can get it work in my local computer but not on the server(coz the server are not mapped to the network drive).
And for case 2, although I can use HTTP_CONTENT_TYPE to retrieve form values but I think I cannot use request.form("aa").count or request.form("aa").item(i) to get select option values.
Page Properties
I ve probably a very simple question but i really can't find an answer. I d like to know in an ASP page what is the URL of the page, the full URL invoked by the client to get the page. I looked in the server object but i did not find.
View Replies View RelatedExcel Properties
I am in need of knowledge about how to control the properties. By properties, I mean font, hyperlink, and color information. I'd like the spreadsheet to have the same data as the HTML page it's getting the data from, but in a different format.
I have been searching in several places, including the Excel Help files, but cannot find any info on how to do this. I'm not asking anyone to tell me how to do this; just looking for where to find out how to do this.
Transaction DDL Properties
According to Access my ADO connection has a value of 16 for the Transaction DDL property. Does anyone know what this equates to? I've found this page -
http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/adosql/adoprg04_83jt.asp
But it doesn't tell me which constant this relates too, and I haven't been able to find an answer at Google either.
Validate: Formobj Has No Properties
i am getting this error message when i validate my page and it is
Error: formobj has no properties
Source File: /sellgiftnum.asp?
Line: 55
and line 55 is this one
var obj = formobj.elements[fieldRequired[i]];
Can someone tell me whats wrong with it .....
Gathering Image Properties
I've uploaded an image to the server and was wondering if there is any possible way to get the dimensions of the image through ASP.
dim iWidth, iHeight, iType
sub ImgDimension(img)
dim myImg, fs
Set fs= CreateObject("Scripting.FileSystemObject")
if not fs.fileExists(img) then exit sub
set myImg = loadpicture(img)
iWidth = round(myImg.width / 26.4583)
iHeight = round(myImg.height / 26.4583)
but I keep getting problems with the loadpicture.
Drawing Page Properties
Is it possible to grab the title of the page and echo it somewhere in your asp document? Does ASP have a premade variable to grab this?
View Replies View RelatedExcel Cell Properties
Is it possible to set a cell property in Excel from an ASP page. We have numerical data that is taken from a database and then displayed in Excel. I would like ideally all the data to be set at 2 decimal places, is there anyway of setting this from the ASP page?
View Replies View RelatedAccesing Office Document Properties With ASP
Does anyone know of a way to access the document properties of an office
document using ASP? I need to be able to read things like the Title,
Author, and Comments fields and pull that information into a web page.
How To Assign Object Properties From XML Content?
Before there was XML my world was in order, I would once a year write some small ASP script, it would perhaps take me all weekend, but it was doable, now the devil has entered my life, in form of an XML file ... Code:
View Replies View RelatedSetting Session Cookie's Properties
I want to set the asp session id path property. How can I do that?
I mean, asp session id is stored in a cookie and like any other cookie it should have properties (or attributes), how can I control it?
Header Properties In The Crystal Reports Viewer.
I want to dislay a query from a database in asp, with the crystal reports viewer.
i can see the report in the CR viewer, but the headings are overlapping each other.
what kind of properties do you have for the report header? Or does somebody know the
sollution? Code:
Error - ODBC Driver Does Not Support The Requested Properties.
I am taking my first crack at writing some ASP and have no clue as to what this error is pertaining to. I will be in your perverbial debt for ever!
----------------------------------------------------------------------------
The error I am getting is:
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
ODBC driver does not support the requested properties.
/agentlookup.asp, line 8
-----------------------------------------------------------------------------
And here is the code it is referencing: Code:
File Properties :: Find Out The Width And Height Of An Image File
is there a way, using asp, to find out the width and height of an image file?
View Replies View RelatedLEFT 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
Upload File To Server And Get File Properties
I would like to add a facility to my web page which allows users to upload basic files (word, excel, text, gif, jpg etc) to the server.
I know there's a facility to do this using HMTL forms, but I don't know how to handle the file on the server side.
What I think I need is an ASP file running some code to manipulate the filesystemobject, allowing me to receive the file and store it in the filesystem on the server. It would be nice to access some of the file properties too (name, type etc).
I've seen a few custom components online which allow you to do this, but I can't depend on installing them. I need to be able to script it myself.
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?
Retrieving
When a new record is inserted into access db it creates an id, how can I return this value for a record I have just created?
View Replies View RelatedRetrieving Value
I have the following code in my form:
Response.Write("<form name='Testing'>");
Response.Write("<INPUT type=hidden id='Testing_txtbox'
name='Testing_txtbox' value='a simple test'>");
Response.Write("</form>");
If I type the following in the very next line, I get a value of
"undefined".
Response.Write("value="+Request.Form("Testing_txtbox"));
why this won't work. and how I can retrieve values of hidden controls via Server side code?
Retrieving XML DTD Doc
I have a DTD xml doc and need to read the data from it and display it using ASP.
View Replies View RelatedRetrieving Name Tag From URL
I want to know if there is a way to retrieve the tag from the URL, I don't know if thats its name, so I'll just explain what it is:
showmsg.asp?FID=mn&ID=2467#2529
the tag, as I call it is what follows the # sign, the number 2529, in this case. so, is there a way I can retrieve the tag with ASP, by the request object, or any other way, any Ideas? Another thing I wanted to know, not related to this subject, is how do I change value of a textarea that is placed in another window with VBscript or JAVA. is it possible?
Retrieving Qty
I have three different tables I will be pulling stuff from: user_info, img_inv, activitylog:
user_info I will be using their ID and state
img_inv I will be using part number
activitylog I will be using part number and date
I'm trying to select the part number from the activities list and match it with the img_inv to make sure it still exist. If it exist I want it to do a total count of how many times it has been looked at by 7 states within a given quarter. Code:
Retrieving Cookie Value
I want to retrieve the value of a cookie to make a form a little more user friendly (our intranet is configured to set a cookie for User First Name, Last Name and Email when they log in)
Unfortunately I can't figure out how to retrieve the value of the cookie. I've been trying:
<%
Response.write Request.Cookies(UserLName)
%>
But it gives me an error - I used Checky to make sure the cookies are there and they do exist:
Name:mascot
Value: UserLName=Tarby
Can someone give me some advice?
Retrieving Values
i want some help in how to retrieve values from multiple selection listbox. i want the values retrived to be used in the search which i perform from the database. i m doing a search feature which u all often see in job search sites. so someone selects multiple cities to search in i want that to include that in my search query.
View Replies View Related