Web Development

Re: Convert seconds to hours in aspx bind?

7-Jun-02 9:53

The method I've used for this type of problem is to create a public method that formats the required output

<asp:textbox id="hours" size="3" text='<%# MyFunction(DataBinder.Eval(Container.DataItem, "interval", "{0}") )%>' runat="server" />

public string MyFunction(string strSeconds)
{
   return int.Parse(strSeconds) / 3600;
}

Todd Smith7-Jun-02 12:30

Todd Smith

7-Jun-02 12:30

That works. thx.

<asp:textbox id="hours" size="3" text='<%# Utils.SecsToHours(DataBinder.Eval(Container.DataItem, "hours").ToString()) %>' runat="server" />

		public static string SecsToHours(string seconds)
		{
			try
			{
				int secs = Int32.Parse(seconds);
				int hours = secs / 3600;
				return hours.ToString();
			}
			catch
			{
				return "";
			}
		}

Todd Smith

Stupid IIS problem

James Spibey4-Jun-02 6:43

4-Jun-02 6:43

HI,

IIS is being a twat. It won't let users download .exes from my web site. They user gets a 404 when the input the URL when I know for a fact that the files are there. Could it be some sort of security 'feature' that is causing this? I have run the IIS lockdown tool in the past - is it possible that this has affected it?

By the way, HTML, ASP, JPG, GIF all work fine.

Cheers

James Spibey4-Jun-02 23:58

4-Jun-02 23:58

For anyone that cares, I think this is due to IIS lockdown as it restricts the downloading fo some filetypes. I'l know better when I get home tonight and try it out.

Remco V6-Jun-02 6:03

Remco V

6-Jun-02 6:03

Try setting the Application Settings (Home Directory) the Execute Permissions on None (or Scripts only).

Next check HTTP Headers, File Types for the Registered file type .exe (this must be application/octet-stream).

Succes!

James Spibey6-Jun-02 9:41

6-Jun-02 9:41

Thanks for the response but it was the URLScan component of IIS Lockdown wheich was restricting the downloading of exes. God know why Smile | :)

Import Excel-files with ASP

Richard Deeming7-Jun-02 0:14

Richard Deeming

7-Jun-02 0:14

URLScan blocks exes because they might run on the server, depending on the configuration. You can comment out the exe extension in the DenyExtensions section of the urlscan.ini file [%systemroot%\system32\inetsrv\urlscan\urlscan.ini], or create an asp page to handle the request and Response.BinaryWrite the file.

HTML Table tabing

Fayez Al-Naddaf4-Jun-02 4:48

Fayez Al-Naddaf

4-Jun-02 4:48

Hi All
I have a data populated in HTML table (3 columns, mutiplerows), I have a text box in the col1,row1. when I press Tab button the focus goes to col2,row1 then col3,row1...what I need is how to make the tabing goes from col1,row1 to col1,row2???????
Thanks in advance Smile | :)

Re: HTML Table tabing

MS le Roux6-Jun-02 9:26

MS le Roux

6-Jun-02 9:26

If you set the tabindex property of the text boxes you can control the tab flow.

Morten, Norway4-Jun-02 4:03

Morten, Norway

4-Jun-02 4:03

Is there a way to import Excel-files with ASP and can you put the data into a database (like MsSQL)

Thanks!!!

Morten

Re: Import Excel-files with ASP

David Wengier5-Jun-02 11:34

David Wengier

5-Jun-02 11:34

Yes, you can use ADO to read from the Excel file, or just the Excel COM objects if it is installed.

--
David Wengier

Sonork ID: 100.14177 - Ch00k

Getting data from local DB into remote DB using ASP

James Spibey3-Jun-02 5:22

Re: Getting data from local DB into remote DB using ASP

3-Jun-02 5:22

Hi,

Here's what I'm trying to do:

I have a local application which stores data (locally) in an access or SQLServer database. What I need to do is pass a subset of that data to a remote database on the internet. There are a couple of provisos though - can only use c++/WIN32 on the client (no MFC or .Net), can use any damn technology on the server.

Here are a few methods I have considered:-

1) Convert to XML locally, upload to server using FTP, parse using XML control from ASP page and write into DB. (bit cludgy)
2) Convert to XML string , write to ASP page as HTTP POST and parse in ASP page.
3) Use some crazy new .NET technology (on the server only) to accomplish this for me?

The amount of data transmitted is likely to be pretty small (~10K).

Anybody have any thoughts/suggestions??

Cheers

Not Active3-Jun-02 13:27

Re: Getting data from local DB into remote DB using ASP

3-Jun-02 13:27

Use SQLXML on the server.

James Spibey3-Jun-02 13:58

Re: Getting data from local DB into remote DB using ASP

3-Jun-02 13:58

Does this allow you to insert into the remote DB. I've had a quick look on MSDN and it looks like it can be used to query remote data sources but I need to insert. I also need the client to work without any special software (like SOAP or .NET).

Can you point me at any links or other info?

Cheers

Not Active3-Jun-02 16:54

Re: Getting data from local DB into remote DB using ASP

3-Jun-02 16:54

Not sure if this will help you but it could be a start

Nick Parker7-Jun-02 5:30

Nick Parker

7-Jun-02 5:30

James Spibey wrote:
I have a local application which stores data (locally) in an access or SQLServer database.

Which one? If you have SQL Server as your source you could create a DTS package to grab information and push it out to another source.

Nick Parker

Page Templates

Chris Maunder3-Jun-02 2:33

Chris Maunder

3-Jun-02 2:33

How do you create page templates? Do you use the old fashioned #include to bring in headers and footers, or create user controls that contain aggregated user controls and HTML for your headers and footers, or do you rely on CodeBehind and inject headers/footers before/after the Rendering?

cheers,
Chris Maunder

VC++ - the language that doesn't say 'no'

Re: Page Templates

Not Active3-Jun-02 13:28