I need to display (and use as a hidden field) the date on a page. How do I change if from MM/DD/YYYY (e.g. 12/25/2004) to 25/DEC/04 . I'm putting it into an Oracle date field and it doesn't like the date in the first format.
View RepliesI'm migrating a system from a mssql to MySQL backend and just ran into problems with ASP's date format. Which is quite different from what MySQL expects to get for a datetime column. And there's calls to now() all over the place.
What I'd like to know is whether there's a way, and if there is what that way might be to change the date output format (DD-MM-YYYY HH:mm:ii) to match MySQL's expectations (YYYY-MM-DD HH:mm:ii).
I have a web page with users selecting start and end date/time. This is being done with DTPicker controls. However, I am having trouble setting initial default values for the date and time. When the page loads, it should show yesterdays date in the control along with 00:00:00 for start time and 23:59:59 for end time.
ie. Since today is 4/5, the controls should be set to 4/4/2005 00:00:00 and 4/4/2005 23:59:59. However, Anything I have tried seems to set the default value to the current date and time. Any Ideas?
I am developing a simple booking system where I had a booking date. The problem is I want to make sure that the user must book 3 days in advanced for certain room.
I have tried to use DateDiff but it seems doesn't work. Actually i just 1 to make sure that the user must book 3 days in advanced from the current date. I am wondering whether there is anything goes wrong in my datediff function. Code:
if for list box, check box or radio button. in asp. how can i write to make it a default value??
View Replies View RelatedI'm using a binary stream to send down a file from the web server. I've been having trouble with IE and getting it to recognize my file. I've added the filename as a paramater(?filename=file.jpgw) to handle IE's mime type mangling, but I'm still having trouble with IE's default Save As Type being HTML. When we send down a jpgw (geo-jpeg) file IE wants to save it as an HTML file. I've got the correct filename showing in the Filename box, and if I choose the All Files option from the Save As Type drop down then the file is saved with the correct extension. I'd like to have the All Files option choosen by default. I know it's just a couple of clicks but we have some noivce users that can't seem to get that
View Replies View RelatedI wrote an application that generates reports.It then presents a page where
I click a button [javascript:print()] to open the print page. However, I
have a fixed printer and would like to know how to print to the default
printer without me clicking anything. So the page will just load up and
print. Or when I click a button. I just don't want the select printer screen
to pop up. Much similar to clicking the print button on top of the address
bar in Internet Explorer.
my new site uses default.asp, instead of using index.asp. this is how my old site was done. now i get error 500. is this because it is trying to find index.asp or because my database isn;t workjing properly? i'm tired and being stupid i think. it's reall probably the database, but i just want to make sure in my sleep deprived state.
View Replies View RelatedI want to make it so that when the user is looking at a rendered ASP page
and they hit the ENTER key, one of the buttons on the form gets "clicked".
In other words I want for the user to not have to click on the button, and
just hit ENTER instead. How do I specify the button?
This is the code for a combo box, and I would like to make certain value the default value, so that appears unless users select somthing else.
call rs.Open("SELECT * FROM Trim.dbo.luDecisionMaker ORDER BY DecisionMakerName" _
, myCon)
do while not rs.EOF
Response.Write("<OPTION value=" & rs("DecisionMakerID"))
if rs("DecisionMakerID") = nDecisionMaker then
Response.Write(" selected")
end if
Response.Write(">" & _
rs("DecisionMakerName") & "</OPTION>" & Chr(10))
rs.MoveNext
loop
rs.Close
It comes from a table and has PropertyDetailsID(1,2,3,4) and PropertyDetailsname(Fee, 5,10,Other) and for example "Fee" needs to be the dafault value.
If a new user is added to the database through a webform, and they would usually have immediate access to member only services, is there a way to make them nonactive in a MS access db until an admin activates them?
View Replies View RelatedI am wanting to compress/zip a file up on the server and email it. Is there a default component that should be installed on the server that will compress/zip files? If not is there FREE ones that anyone would suggest?
View Replies View Relatedwith "select @@IDENTITY" i get the value of the last field insered.. i would
like to get also the field.name
Is it possible to add a default include file to every ASP-page servered on IIS? So I do not have to modify every page.
View Replies View RelatedHow do I make a value the default value for a combo box in ASP 3.0?
What I have below does NOT work, yet I've seen it in HTML file examples before (and works if I put it in a HTML file by itself, but not if I use it in a ASP 3.0 app.
<select name="cboCompany" style="text-align:right; font-size:8pt">
<option value="08">08</option>
<option value="09" selected="true">09</option>
<option value="33">33</option>
<option value="18">18</option>
<option value="17">17</option>
</select>
The following code works fine for PC but not for MAC. It won't select the default image from the DB. When I check the DB there looks like there is Binary information there but nothing is displayed ....
View Replies View RelatedUsing a DetailsView to update data in SQL 2005, How do I change the default "Update" hyperlink to a more user friendly button?
View Replies View RelatedI need a string of code that will allow me to eliminate,exclude,or ignore the default values that are sent in my web form.It is an order form that has hundreds of items.The items not selected show up looking like this in my email box.
ANCPW122=0
p1E1=0.00
ANCPW182=0
p1E2=0.00
ANCPW183=0
p1E3=0.00
ANCPW242=0
p1E4=0.00
and I have to sort through all of them to find the few selected.can any one tell me with some type of loop to eliminate the values returning 0 or 0.00.
i set up iis 5.0 on my local machine(win2kpro) (on a pvt LAN) at the default port. when i try to access asp it gives http 500 error. i have been able to configure cgi scripts but asp still doesnt work.
View Replies View RelatedI have two drop down lists on one of my pages.One of the them lists all the MONTHS in a year, second one list a number of years starting for 2004. Users couldn't be bothered selecting that every time they are filling it in for submission, so they want me to popolute the two fields with the current month and the year automatically.
Plus the month has to be selected as a current month up to the 7th of every month,on the 7th it changes to the correct month. of basically if date is < 07/08/2004 = July.
Is there available some list of COM components available to ASP pages, that are available on virtually every IIS machine?
I am wondering wether there is some right-away-available API with cryptogrphy functions. The particular function I need is MD5 hash estimation for files. I have one written in JScript, but it would be very slow for larger files.
Is it possible to reset a SQL field to it's default setting? For example, someone changes FIELD1 to "John Doe" and the the default is "YOUR NAME". Can I reset it back to "YOUR NAME" somehow?
View Replies View RelatedI am getting the above error message on a non-default website. But, default.asp and other asp files work properly. There are few asp files which are residing on this non-
default website created by our application folks, and it is not working.
Server Details
Win2k SP4
IIS 5.0
URLSCAN is installed
C2 Security Settings implemented on the server.
let me know what could be wrong.
I got the following error when access an asp page.
Response object error 'ASP 0185 : 8002000e'
Missing Default Property
/downtime_category-old2.asp, line 0
A default property was not found for the object.
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.
I have setup an IIS 6 server and I am trying to migrate a pretty basic website to it. It will display any ASP page that I set as the default page, but gives a 404.2 for any
other ASP pages that I link to.
What am I missing?
By default, Weekday setting starts on sunday which is 1. How can I change to
use Weekday to start on monday?
All I want to do is set a session variable in my default page which points to a directory on my server where all media for my site is contained. Now, I used a session variable to do this, and fell into a trap. Say I set it up like this:
Session("mediadir")="D:dev<sitename>media". Now, when anyone looks at my site, the mediadir variable is trying to point to their d:dev.... What should I do. I know it is crazy, but I have mental blank.
I have a list box with a number of values (4) on a ASP form, the value is stored in a database field.
When a form to amend the record is loaded, I would like to display the list box with the currently held value as the seleceted item in the list box. e.g.
4 items in listbox A B C D
B selected and saved.
Amendment form displayed, List box contains A B C D, with B highlighted.
Is this possible with ASP?
How do I display 'Please Select' as the default value my code is below.Code:
<option selected>Please select</option>
<%SQLStmt = "SELECT magcode FROM Magazine ORDER BY Magcode"
Set rsDistMags = Connection.Execute(SQLStmt)
Do WHILE NOT rsDistMags.EOF%>
<option value="<%=Trim(rsDistMags("magcode"))%>"<%If Request("magcode") = Trim(rsDistMags("magcode")) Then Response.Write " Selected" End If%>><%=Trim(rsDistMags("magcode"))%></option>
<%rsDistMags.MoveNext
Loop%>
</select>
i using the iis on my comp as a server.if i dun have a index.html or default.html page in my directory then when i enter //localhost then all files will be shown.now i put a index.html page inside the directory.. it will open up the index page when i enter localhost.i wan to link a page from the index.html page to the main login page.how do i do it?
View Replies View RelatedDoes anybody know the default session expiration?
View Replies View RelatedI am loading some images from my database,however some records don't contain any images. in these circumstances, instead of a blank space appearing,I would like to load a default image; how do I do this?
Is it something like?
Code:
If Len(rs.Fields("ImgPath1")) > 0 Then