Recent content by mana2

Hi, Is it possible to have an if or case type statement in the SelectCommand in Formview? I have a combobox and if the item doesn't exit I need to add it to the lookup table and then if it does exist, I need to just insert the value into the main table. So it would be something like this...

I have a Combobox where the list can be edited and I'm trying to update the text which is read from 2 database tables but I'm having trouble doing that. Customer Table: CustomerID and Customername (Lookup Table) Product Table: Customer (Contains the CustomerID from Customer Table)...

Hi, I have 2 pages. The first has a formfield that gets an input from the user and the second page displays the results. I'm using the FormView item from the toolbox in Visual Web Developer and the Edit, Insert and Delete options don't show up. No matter what I use in the Selectparameter, form...

I'm having a problem searching on a field in a database: I have a two pages. The first is a form that contains an input field Product Type. The second page takes the field and runs it in a select statement. If I hard code the value, it works: Dim strSQL As String = "SELECT * FROM ProductType...

Thanks for your help. I might have to reinstall IIS. I was hosting with an ISP and then moved it to an internal server.

Yes but a bit different from what you listed: C:\WINDOWS\system32\inetsrv\asp.dll instead of C:\Windows\system32\asp.dll Verbs: Limit to GET,HEAD,POST,TRACE

I did set the execute permissions to Scripts only: Under IIS Manager/Web Sites I looked at the properties of the web site. Under the Home Directory tab under Application Settings, I set the following: Application Name: Default Application Starting Point: <Web site name.com> Execute...

The ASP pages all worked on a different server. I created a simple HTML page and gave it an ASP extenstion and it would still not display. Thanks

Yes. The page cannot be found error.

Hi, I did add index.asp as a default content page under the documents tab of the properties dialog. Not sure what else to do. Thanks

Hi, My ASP files were running at a web host but when I copied them over to a different server, the ASP pages don't work. HTML pages do. Under IIS/Web Sites I looked at the properties of the web site. Under the Home Directory tab under Application Settings, I set the following: Application...

Thank you so much to both of you. I'll try it out.

Hi, I have a drop down list and once it's submitted, I'd like to display it again with the selected value. This works but then I have the value listed twice. <select name="position"> <option selected>Choose One</option> <option value="director">director</option> <option...

Thank you so much for your help. The identity was being dropped on the ID field when I exported the database. It's working now.

I'm creating the database in Microsoft SQL Server Management Studio and set the Identity on the ID column. I did use the Import and Export Wizard to export the database and I was wondering if it drops the identity on the ID field. I did try creating the table with the script Markros had but I...