Search results for query: *

Thanks rac2 and tsdragon for your replies. Tsdragon's response was a winner--it works great. Thanks for your assistance :) -Dan

I've got a variable called test that I declare in the following function in an include file: ------------------------------------ function checkApplication() { if (document.jolApply.platform.options[document.jolApply.platform.selectedIndex].value == "null") { alert ("Please...

What's the difference between between these two statements--they appear to do the same thing, but the second one doesn't work: CallableStatement cs = con2.prepareCall("{call harmerd.FERPmonthlybyregion (?, 'CL%')}"); cs.setString(1, "harmerd." + timeperiod)...

Nope :) Still got the problem. This is driving me nuts... By the way, I'm just using the jdbc-odbc-bridge in case that matters. So who's the bad-to-the-bone programmer who can figure out what's wrong here? Thanks 8-) -Dan

The following servlet code snipets calls a stored procedure in SQL Server: ---------------------------------------------------------- String timeperiod = (request.getParameter("StartMonth") + request.getParameter("StartYear")); String region =...

Thank you for the responses thus far. To clarify, what I'd like to be able to do is pass multiple 'where clauses' to the procedure. For example, I may want the where clause to be: "where exists (select * from ' + @selectedview + ' where pool like "CL%")'" but I might also...

I've got a procedure that essentially creates and runs a select statement on a view that is specified via a single parameter. I'd now like to add multiple 'where conditions' to the generated statement in the procedure via using additional parameters. For example, here's my original procedure...

I think I just realized my stupid mistake--I was typing this: execute harmerd.FERPview harmerd.mar01 instead of this execute harmerd.FERPview "harmerd.mar01" I forgot the stupid double-quotes (I feel so foolish :) Anyway, thanks for helping a newbie. -Dan

Forgive me John, but I don't understand your last reply? I don't want to drop a view, what I want the procedure to do is let me pass it the name of a view and return it's contents. I thought that having a procedure to generate a select statement that would return all rows would accomplish...

Thanks for the response--I have another question. Now assuming that I have a view named mar01 (harmerd is it's owner), how do I execute FERPview and pass it the value mar01? I tried this: execute FERPview mar01 and this execute FERPview mar01 I want to somehow pass the value mar01 (or...

I'm trying to create the following procedure in MS SQL Server 7.0 I get an error "Error 170: Line 3: Incorrect syntax near '@selectview'. Line 3: Incorrect syntax near '@selectedview'. I want @selectedview to be a parameter name (for the name of a view) I want to pass to the procedure...