Search results for query: *

A few ants short of a picnic Dumber than a box of rocks

What type of database are you using? You need something called an outer join. If you are using Oracle, you can do something like this: where messages.seqnum = topics.messageseqnum (+) this brings back everything on the side of the relationship with the +, and only the joined stuff from the...

Before you respond too defensively to the developers, think through how you are presenting your questions to them. I am currently dealing with a frusterating situation with a coworker. This is exactly what is happening to me, except I am the developer. I originally developed a system, but...

ok, thank you so much for the tip! I have been suspecting that it might be something with the connection pool. I will try the change with the web config, and see if I can confirm that this is the problem. I really appreciate you responding - clearly there was something wrong, but I haven't...

Any ideas? We are live now, and this is a major problem! Even if you could help me figure out something new to google, I would really appreciate it!

I have a major problem on my test and production servers with a particular application. The application is set up with an application layer and a data access layer. The data access layer uses the Oracle managed provider (System.data.OracleClient?) Every so often (about once a week...

Thanks so much for your ideas! It ended up that a different program that some of us installed changed the NLS_LANGUAGE setting in the registry, but it only affected queries using the system.data.oracleclient managed provider. Wow, that one had me running in circles for a while there! Thanks...

I am at my wits end and need some troubleshooting help. I am writing a dynamic reporting tool. Users can pick a number of search criteria and output criteria, then hit search and get a grid filled with their results. It is fairly dynamic - the available output criteria are driven by a...

I don't think it really hurts anything for the event to fire as long as the code in it only runs when you want it to. Can you somehow check that the desired panel is visible by wrapping the page load code in an if then statement? The event will still fire, but won't do anything. It is still a...

Paul, thanks for the great info! The bit about throwing it up to the caller was particularly helpful to me, as I usually catch things but the messages get lost before they bubble up to the top. The one question I had was about the divide by zero exception. Isn't it more correct to do a...

I have done something like this: [code] select 'cust' AS LOGTYPE, name AS USERNAME, pass as PASSWORD FROM tblCustomer UNION select 'emp' AS LOGTYPE, username as USERNAME, password AS PASSWORD from tblEmployee UNION select 'bus' AS LOGTYPE, username as USERNAME, password AS PASSWORD from...

If the whole statement is not on one line and you aren't using the _ for continuation, you need an end if

I think this is what you want: <asp:HyperLink id=HyperLink2 runat="server" CssClass="DepartmentSelected" text='<%# DataBinder.Eval(Container.DataItem, "Name") %>' NavigateUrl='<%# "../default.aspx?DepartmentID=" + DataBinder.Eval(Container.DataItem,"DepartmentID") + "&amp;DepartmentIndex=" +...

Also, I would change this: if rs.eof Then Response.write("No records Returned") end if do until rs.eof Response.write(rs("StaffID")) rs.movenext loop to this: if rs.eof Then Response.write("No records Returned") else do until rs.eof Response.write(rs("StaffID"))...

When you try your insert directly to the database instead of through ASP, are you retyping, or copying directly from the response.write output? I would make sure you are copying it, because if you are retyping, you may be unconsiously fixing a syntax error. I'm not sure about FoxPro specific...

I'm not sure, but can you put a breakpoint on your Page_load within the user control and use the debugger to see if you hit it if the panel is hidden?

Just for fun, try hardcoding in values for Region, boardID, Zip, and any other variables that are integers instead of taking the text box values and see if the errors go away.

try doing a response.write("") somewhere in your code, probably in a loop. The problem is that ASP.NET sets a timeout limit on a thread executing with no response. By doing a response.write, you will be letting the server know that it is still working. You don't really want to increase that...

There is a whole thread on that that has been on the first page here for several days now: thread855-814497 Have you tried reading that at all? After reading it, do you have any specific questions? It is basically the exact same question, so hopefully some of the advice can help you

basically, make any properties that you want to change public in your user control. Then, in the web form, assign those properties a value. For example, if you have Public nName As System.Web.UI.WebControls.TextBox in your user control, you can access it through the web form like this...