Recent content by j9

I need to keep similar tables in two different databases in synch. This is what I want to do: -Any column update to database1.mytable should trigger the same column update to database2.mytable. -Any column update to database2.mytable should trigger the same column update to database1.mytable...

I think what I want returned is: Select *fields that you want to display* from table1 where title like "%Component Developer%" AND title like "%Magazine%". The title should contain all terms in the search criteria and should search for full terms if the user put it in quotes, e.g. 'Component...

How would we write code to parse statements to account for various user entered search criteria, similar to the searches you can do with Google? For example: If the search is for a Title and the user enters: "Component Developer" Magazine, how would we write the sql code to search for titles...

I have a javascript function that is called when I click my server-side submit button. I want to validate that one of my labels is not empty before allowing a submit. I cannot figure out how to access the value stored in myLabel.text. For hidden form variables I use the following syntax in...

Good point on the db hit. I think I'll go with a session. Thanks for sticking with me!

Thank you very much for your help, but I was trying to avoid sending the id in the URL. I guess I can just use a session.

Yep, I ran into the read-only exception, too. I was trying to give a simple code example. What really happens is this: 1. The user fills in a bunch of text fields to create a new record. 2. The user clicks the 'save & continue' button that calls btnSubmit_Click(). 3. btnSubmit_Click inserts...

Unless I'm missing something, Server.Transfer("AnotherPage.aspx",True) does not pick up the values that were changed server-side. I think tgreer is right in that I need to change the http form data. I'm just not sure how to go about it. Thank you.

Thank you, but how do I do that? What is Request.Form.Set()? I couldn't find any documentation.

I have a textbox, txtName, runat=server. When the submit button is clicked, I want to change the value of txtName in the code-behind page and then submit the changed form variable to another page. It seems that the value of txtName must also be changed client-side in order for the value to...

Just concatenate it to your string like you would any variable.

I used to use ColdFusion's <cfabort> tag to end processing of a web page if a certain condition was true. For example, if the user came from the wrong page, I would display an error and then use <cfabort> to prevent the processing of the remainder of the page.

In C#, it's Environment.NewLine

My fix: I put the arraylist in a session variable and then reset the datasource in the EditCommand event handler. I was trying to avoid calling populateform() because it does a lot of other things (calls to db, etc.). Does this sound like an OK way to do this or am I going to get myself into...

I have a datagrid with an arraylist as the datasource. I added an Edit, Update, Cancel button column and coded the EditCommand event handler. When I click on the Edit button, the datagrid disappears. Have I lost my datasource during postbacks or something? Here's my code: private void...