Recent content by ajliles

Thanks for your help. I've pasted the current SP below, which is fairly rigid in order for the execution to be as efficient as possible (without resorting to dynamic SQL). At the moment this works very well, but I'm now trying to change this so that the @Type, @GroupID and @Criteria can be...

Many thanks, everyone. I think I will try the loop-until-null solution. In my experience, temp tables can cause many performance issues, bottlenecks, etc, so I will try other options first. Adrian.

Okay, thanks for the help so far. I'm allowing the user of my web application to define their own database query (consisting of as many sub-queries as they like, all linked by an OR). The user can then search the database and if necessary remove or edit a sub-query. Each sub-query could be a...

Hi, Is it possible to call a stored procedure and pass to it a number of parameters that can vary at run-time (from 1 upto the max 2100). I would like the stored procedure to be flexible enough to determine how many parameters are present and then build up a where clause within a loop. I know...

Yes, I have to use word because I'm starting with a document template and just filling in the gaps using script - the template contains a number of tables and some graphics; and also because the generated report is just a starting point - once generated the user can then edit, print, email, or...

Hi, I'm currently generating reports on-the-fly by automating Microsoft Word on the client from a web page using javascript. This works fine apart from being very slow - I understand that this is due to the way that javascript binds to ActiveX objects at run-time (ie, late binding). Does...

I've now got it working - I found out that certain characters were being stripped (in a function called from a parent frame) before getting to my validation function :-)

Just tried this on IE5 and it doesn't work :-( Adrian

Thanks for the reply, but still no luck! Using your pattern I can enter the following and it works fine: (11) 11 11 ext 11 but when I try the following it fails: +11 (11) 11 11 ext 11 So for some reason I have a problem when the user tries entering the + sign. Escaping with \+ doesn't allow...

Hi everyone, I'm trying to use regular expressions in javascript to validate an international phone number, and I can't get the regular expression to test for +. The pattern I'm using is: /^(\+)\d{1,3} [\d ]+\d$/ I think this is a bug because if I use the following pattern, it accepts $nnn...