Web Development Discussion Boards

Re: Problem with Active

Johnny ²13-Jun-07 17:42

Johnny ²

13-Jun-07 17:42

You can't use 'text-decoration' as a variable name as the dash is seen as a minus. Instead use:

style.textDecoration

Reading an excel file using ASP

acerunner31613-Jun-07 16:08

acerunner316

13-Jun-07 16:08

<br />
dim xlsConn, xlsRS<br />
set xlsConn = Server.CreateObject("ADODB.connection")<br />
xlsConn.Open "Driver={Microsoft Excel Driver (*.xls)}; DBQ=" & uploadsDirVar & "\" & fileName<br />
<br />
set xlsRS = Server.CreateObject("ADODB.recordset")<br />
xlsRS.open "SELECT SerNumber,IO2,ICO,IH2,I1,I2,KA,R FROM AddCalData", xlsConn<br />
<br />
xlsarr = xlsRS.GetRows()<br />

The problem is that the excel file has some fields that are optional. If the some of the fields in the first data line are empty, then the remaining data in that column is lost. All data are numbers. I think it has something to do with formatting. Maybe the drivers need data in the first column to determine datatype. I found somewhere that putting IMEX=1 in the connection string will make it not restrict datatype. I did not work.

If the first column has all fields filled in, then the remaining data is fine. Please help. Thanks in advance!

event location

Ali Tavakol13-Jun-07 5:45

Ali Tavakol

13-Jun-07 5:45

dear all,
I want to know where the user right-clikced the page.
window.event.x returns the x position relativew to the top corner of the screen. I want to know the position relative to top of my document. (when the page has a scroll-bar, these two values differ).

Scroll Problem in Div

Panchal Hardik13-Jun-07 2:34

Panchal Hardik

13-Jun-07 2:34

Hi,
I have a horizontal scroll bar in the Div. Now when Page Load then I need to show the right edge (right corner) of the scroll bar of the div.

Thanks

Hardik Panchal

Membership fees

john3413-Jun-07 2:30

john34

13-Jun-07 2:30

Hi all,

I hope I have put this question in the right place – if not Sorry!

I am in the process of making a website and have decide to make it a members only site and to charge a small monthly fee to join.
However I don’t want users to have to input their details each month. So is there service that will take a monthly reoccurring fee ?

I was reading up on EPDQ but it all sounds a bit big business for me ! I only want to charge a tiny amount (possibly £1 per month per member) but just need a simple way to make this charge each month ! I don’t want to be responsible for the transaction myself – the security problems with customer details would scare me.

Any ideas ???

Thanks
John

Re: Membership fees

Johnny ²13-Jun-07 3:13

Johnny ²

13-Jun-07 3:13

You'll probably not find many payment processors setup for such small fees. You would be better off grouping payments together so people have to buy 3 months, but each month is only £1. PayPal have a recurring membership and is likely to be the easiest option.

Re: Membership fees

badgrs13-Jun-07 3:19

badgrs

13-Jun-07 3:19

Beat me to it damnit! Wink | ;)

Re: Membership fees

badgrs13-Jun-07 3:18

badgrs

13-Jun-07 3:18

For £1 a month it will hardly be worth your while, any online payment service will probably charge you around 50p just for the transaction, you'd be better off billing yearly. You can do subscription based payments with PayPal (I've payed my web hosting like this for a few years now), I think its pretty simple to do as long as you don't mind using the PayPal payments screens.

Re: Membership fees

intonet14-Jun-07 6:16

intonet

14-Jun-07 6:16

Using PayPal as your merchant will cost you 23.5p on a £1.00 transaction (3.4% + £0.20p). Potentiall not the end of the world if you can then upsell to your clients.

Using the PayPal PayFlow Pro .NET API it's a piece of piddle to integrate into your web site. It's about £20.00 a month for the PayFlow subscription, with a further charge for recurring payments. www.paypal.com

Re: Membership fees

john3413-Jun-07 21:36

john34

13-Jun-07 21:36

Thanks all !!!

I will definatly have a go with paypal ! and grouping the payments does sound like a good idea !

Thanks again Smile | :)

Re: Membership fees

Tauseef A13-Jun-07 21:53

Tauseef A

13-Jun-07 21:53

what the sh*t is that ? what the hell is this goin on ?

hello

Re: Membership fees

john3413-Jun-07 22:31

john34

13-Jun-07 22:31

Hi,

I am not sure what you are referring to ? Confused | :confused:

ghumman63 wrote:
what the sh*t is that ? what the hell is this goin on ?

Please feel free to reply with a more specific question

Thanks Wink | ;)

AJAX using DIV throws a runtime error

ajisthekingofpop12-Jun-07 22:59

ajisthekingofpop

12-Jun-07 22:59

I have a div which is embedded inside a table.

I can manually find the element using getByElementId("mytag");
I can even statically assign innerHTML, but my problem occurs when i try and assign it the responsetext from a XMLHTTP Object.
If the DIV tag exists out the table on its own, then everything workds fine,
its just when the div is embedded inside a table or even a form.

What am i doing wrong, someone please help.
I can document.write the responseText and its correct,
I can even statically assign 'hello' to the innerHTML of my tag and all works.

Any suggestions would be appreciated.

Re: AJAX using DIV throws a runtime error

badgrs13-Jun-07 1:27

badgrs

13-Jun-07 1:27

Without any code I don't think anyone can really help.

Re: AJAX using DIV throws a runtime error

ajisthekingofpop13-Jun-07 11:25

ajisthekingofpop

13-Jun-07 11:25

the Jscript code is:
function GetXmlHttpObject()
{
var xmlHttp=null;
try
{
// Firefox, Opera 8.0+, Safari
xmlHttp=new XMLHttpRequest();
}
catch (e)
{
// Internet Explorer
try
{
xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
}
catch (e)
{
xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
}
}
return xmlHttp;
}
function stateChanged()
{

if (xmlHttp.readyState==4)
{
alert('got data');
//document.writeln(xmlHttp.responseText);
var item = document.getElementById("cont");
//alert(item);
var res = xmlHttp.responseText;
item.innerHTML = res;
//.innerHTML=;
}
}

function loadArticle(id){

//alert('id is ' + id);
xmlHttp=GetXmlHttpObject();
if (xmlHttp==null)
{
alert ("Your browser does not support AJAX!");
return;
}
var url="articles.aspx";
url=url+"?id="+id;
xmlHttp.onreadystatechange=stateChanged;
xmlHttp.open("GET",url,true);
xmlHttp.send(null);

}

the htnl sits klike this

o.k assigning just "hello" to the innerHTML of cont works fine,
but try and assign responseText and I getthe runtime error.

Re: AJAX using DIV throws a runtime error

ajisthekingofpop13-Jun-07 11:27

ajisthekingofpop

13-Jun-07 11:27

there is a < div > tag but it disappeared on posting. Its in the table cell.

Re: AJAX using DIV throws a runtime error

bartedgerton15-Jun-07 9:37

bartedgerton

15-Jun-07 9:37

Have you tried it in different browsers? I wonder if its a client-side error or a server-side error. You might also check to make sure you don't have a reserved name issue.

Bart Edgerton
http://www.ewebdev.net

Data Grid ISsue

Tauseef A12-Jun-07 21:55

Tauseef A

12-Jun-07 21:55

Hi guys

i am facing a problem , i am sorry if i am ignorant actually i am a bit new to asp.net,

the problem is that i have bounded my datagrid with data source(Data set object),
when there are large number of records the size of the grid is perfect, but when there are limited records in the dataset object for e.g 1 or 2 so then the row height of the data grid gets increased and looks very much odd, i must be missing some thing, but please any help will be highly appreciated,

Thanks in advance
Best Regards

hello

Re: Data Grid ISsue

PrakashBhaskar13-Jun-07 2:49

PrakashBhaskar

13-Jun-07 2:49

you can specify height and width for row and column by using grid property

for example if you want to make alternating rows should have static height you can select alternatingitemstyle from the grid propery window there u can specify your styles this is one way.

or your can use style sheet

or if u go to grid propertybuilder you can see the "format" menu there u can specify your styles.

Thanks
Warm Regards
Prakash-B

Autometic software updation process

Elena200612-Jun-07 19:00

Elena2006

12-Jun-07 19:00

Hi
There is the requirement of autometic software updation process. We need a method where the admin will check for updates with a button in the GUI, and the system will self-extract and install on it's own. We're going to get many customers on our project, and need automated processes for this.

Please give the idea how it is possible both for Window and Web based application. We are using .NET as well as Delphi application.

Re: Autometic software updation process

Sathesh Sakthivel12-Jun-07 19:41

Sathesh Sakthivel

12-Jun-07 19:41

Go with Windows Scheduler.

Regards,

Satips. Rose | [Rose]

Re: Autometic software updation process

Pete O'Hanlon13-Jun-07 2:29

Pete O'Hanlon

13-Jun-07 2:29

Take a look at ClickOnce. This is what it is designed for.

Deja View - the feeling that you've seen this post before.

Re: Autometic software updation process

Vasudevan Deepak Kumar15-Jun-07 3:45

Vasudevan Deepak Kumar

15-Jun-07 3:45

I would suggest BITS. Check out this one:

http://msdn.microsoft.com/msdnmag/issues/03/02/bits/[^]

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

How can I created a row clickabe GridView?

kidus1212-Jun-07 16:04

kidus12

12-Jun-07 16:04

Hi How can I created a row clickabe GridView?
I appreciate your cooperation
kidus

Re: How can I created a row clickabe GridView?

szukuro12-Jun-07 22:09

szukuro

12-Jun-07 22:09

In the RowDataBound event handler write:

e.Row.Attributes.Add("onclick", script);

where 'script' is either some javascript for client-side action or if you implement the IPostBackEventHandler, it can be a postback event reference, for server-side processing.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.