Web Development

Brendan Vogt31-May-05 21:10

Brendan Vogt

31-May-05 21:10

I think you can pass a NULL to a stored procedure, but when I leave the length property blank, or out, then I also get an error. So if I can find a way to pass this, then I think it should work.

I have seen other stored procedures where they also use = NULL.

Can you maybe send me the CreateParameter string for adding s null value in C#? Maybe I can follow from that. Do they also require a length firld?

Please guys, help me out on this? I am new to stored procedures.

NeverHeardOfMe1-Jun-05 9:57

NeverHeardOfMe

1-Jun-05 9:57

I don't care what the purists say, my advice is to avoid null values like the plague! Define all the db fields you can as NOT NULL and do whatever you have to fit in with it. In your example, for a ContactDialCode, siomply store an empty string instead. A plague upon NULLS!
cheers
Phil

Christian Graus1-Jun-05 11:37

1-Jun-05 11:37

ROTFL - at least you know this is a religious discussion. Sometimes, NULL has a real meaning ( for example, no string has been entered, as opposed to an empty string was entered ).

I believe it's a decision that's up to the consience of the individual churchgoer, but there are definately times when NULL is a meaningful value.

Christian Graus - Microsoft MVP - C++

Update HTML programmatically

NeverHeardOfMe1-Jun-05 13:32

NeverHeardOfMe

1-Jun-05 13:32

yes, I know.... but since when did reason ever get in the way of reigion? Nullify NULLs, I say! (And as for the egghead who decided to use apostrophe's as string delimiters in SQL...;P)
Big Grin | :-D

Phil

asp

Anonymous31-May-05 17:52

Anonymous

31-May-05 17:52

how can i refesh the form/document (like f5 key) through the coding in asp

Re: asp

Anonymous31-May-05 18:21

Anonymous

31-May-05 18:21

ASP is a server technology. You can't refresh the users screen from the server. However, you perform a location.refresh() in javascript.

Re: asp

Vasudevan Deepak Kumar10-Jun-05 0:07

Vasudevan Deepak Kumar

10-Jun-05 0:07

You need to emit a client side JavaScript code to achieve this.

<Script Language="JavaScript"><br />
  self.location.reload(); //refreshes the current window page<br />
</Script>

Deepak Kumar Vasudevan
Personal Web: http://vdeepakkumar.netfirms.com/
I Blog At: http://deepak.blogdrive.com/

frycdf31-May-05 9:21

frycdf

31-May-05 9:21

I have the need to insert a snippet of HTML into about 400 separate web pages. The first possibility is obviously to just open each file (different domains and accounts) paste the code and save (via MS FP).

Being the lazy person I am, I was hoping to someohow programmatically (ASP, VB etc) build something that can update those pages all at once (given the appropriate page name and login creds).

Any ideas?

TIA...

Christian Graus31-May-05 12:21

31-May-05 12:21

You want to write code that logs in to a remote web server, changes the HTML and then saves it ? No, that won't work. You'd need to FTP to the server to do that.

If your pages are XHTML, then an XSLT would be able to update all the pages for you.

Christian Graus - Microsoft MVP - C++

frycdf1-Jun-05 4:31

frycdf

1-Jun-05 4:31

Actually, I was planning on doing it via FTP and just wanted to find the best way/tool/method to programmatically update the file once I have it downloaded.

In other words, my program will grab the FTP address, login, download the file and then somehow modify it and put it back.

NeverHeardOfMe1-Jun-05 10:13

NeverHeardOfMe

1-Jun-05 10:13

If you have write permission on the server, you could write an ASP.NET page that reads the files one by one, one line at a time, and writes them out to a temp file, inserting the required extra code along the way. Then rename the temp file as the original. Move on to next file. This kind of assumes the change is the same for all files, and there is some way of telling the script where to insert the new bits (eg, after the body tag)

This is not that hard to do. Examine the system.IO class for file functions, and the StreamReader and StreamWriter objects.

cheers
Phil

Christian Graus1-Jun-05 11:15

Returning array from VB component to ASP Page

1-Jun-05 11:15

If it's XHTML, then an XSLT would be the best bet, IMO.

Christian Graus - Microsoft MVP - C++

Pavneet Singh31-May-05 6:33

Pavneet Singh

31-May-05 6:33

I am working on ASP as front end and VB as middle layer, in an application. I need to use an array from VB in ASP. How to write the Let and Get properties for the same.
all help is appreciated. Thanks

Domain Masking Code

Anonymous30-May-05 14:09

Anonymous

30-May-05 14:09

I'm new to web sites and just learning so will someone with knowledge please help me figure out this?

I have 2 domain names. I have 1 hosting account. I have domain name #2 pointed to domain #1. for example: when putting www.domain1.com in the address bar it goes to domain #1. when typing domain #2 in the address bar it goes to domain #1/domain2

I was told that I can add more pages to domain #2 and put a mask code on the pages to make them work in domain #1 and the address bar will show the address domain #2.

I hope I'm expaining this correctly. I was told to go to google and do a search for datml masking code and I would find a code to put on the pages. I didn't find a code. Does anyone here know a code that will do that?

Thanks in advance,
Kozy Kitten

shifting items in b/w list boxes

azam31630-May-05 5:23

azam316

30-May-05 5:23

hi,
i have 2 list boxes on my aspx page. i need to have a functionality that,
whenever a user double clicks an item on any of the list boxes, it shifts to the other one. i am using a javascript for this purpose as there is no double click event provided.
the script is working and the items do shift. but when a server web control such as a button is clicked, all shiftings made by double clicking revert.

please help me. do i need to use viewstate? if i do, can anyone tell me how?

if there is another way please do tell me!

thanx in advance

☺«««DTA»»»☺

Re: shifting items in b/w list boxes

JKroschel30-May-05 13:26

JKroschel

30-May-05 13:26

You can fake a double click event with javascript. Look here: http://www.chipchapin.com/WebTools/JavaScript/example3-01.html[^]

Write a special program(xxx) :D

rockxuyenmandem29-May-05 23:44

rockxuyenmandem

29-May-05 23:44

Pls suggest me any idea to write a program to convert from MS Access Database to MySQL Database.
Thanks and regard.
Big Grin | :-D

I tried so hard and got so far

Re: Write a special program(xxx) :D

JKroschel30-May-05 13:35

JKroschel

30-May-05 13:35

I use Access to work with several MySql databases by linking tables through the ODBC.
First go to http://dev.mysql.com/downloads/connector/odbc/3.51.html[^] to download the ODBC driver for MySql. Create a DSN for the MySql database on your local computer. Open Access, go to File->Get External Data->Link Tables (be sure not to use import, because that will only work locally), and select ODBC in your file type drop down list. Under "Machine Data Sources", select the DSN you created. Select all the tables you wish to work with, and you will get icons for each under your tables list in your access window, except they look like globes instead of tables since they are linked tables.

Now that you have the tables set up in access, you can work with them however you want, including queries, forms, reports...whatever.

Using session states?? :((

Member 191349829-May-05 23:15

Member 1913498

29-May-05 23:15

Hi Everyone,

I am very new to ASP.NET (student on work placement!) and I have created a form & table page which works no problem, the problem is when I try to split them up onto two pages. Cry | :((

I have a form page with loads of fields(around 50) a mix of ddl's, text fields, checkboxes etc. that the user fills in e.g. to list ingredients and prices for a new article. From this I have created a dataset to hold all the info. Then I also have another page that is a datagrid that lists a summary of the users articles using the dataset but only a few of the fields, when the user wants to edit a row in the table they will get redirected back to the form and all the articles information will be filled into the appropriate fields. So my question:

Do I have to create session state variables for every single field and then set them in the form page's page_load handler? or is there a easier way, something like creating an object of the table row like:

datasetIndex = e.Item.ItemIndex
activeRow = oDsArticle.NewArticle(datasetIndex)

and sending it in a session state and then somehow I can access all the fields through this object? I need all the help I can get!!!

Thanks in advance!

Sharon

Re: Using session states?? :((

Christian Graus30-May-05 12:19

Re: Using session states?? :((

30-May-05 12:19

Avoid session state, this is ASP.NET Smile | :)

The way to do this is to make both of these pages controls, then put them both on the one page, and make the navigation between pages hide and show them, so only one is visible. Then all your control variables will be available to you in your viewstate ( that is, you can just address the values in the controls on page 1 through properties, and pass them on to page 2 the same way )

Christian Graus - Microsoft MVP - C++

31-May-05 2:04

Christian,

I have a page with both on it plus then I split them up onto 2 pages but how do I make them page controls?

and I know how to hide and show parts of a page when I am using panels(do I have to use panels?? I don't want to if its possible) but when I show one it is shown in the position it is on the page, how can I place it at the top of the page to make it look like a new page?

I don't really understand what you mean, could you maybe give a simple example?? I am trying a million different things and now I am totally confused. Confused | :confused:

Thanks,

Sharon

Re: Using session states?? :((

Christian Graus31-May-05 11:09