I included <SPAN> tags (with IDs of "text_" + the corresponding <SELECT> value). Those spans are to be filled with the respective content and are invisible by default. When the "Go" submit button is...
Eventually I took some time to familiarize myself with table indexing and four CREATE INDEX-es later each of those 60+ seconds queries executes for less than a second...
I tried to find some info, but no success so far:
1) Does "WHERE 1=1" affects execution performace?
2) If so, can someone propose a better solution for my data reports?
I edited my example (by adding "p.class = p.className", for different browsers use different attribute names). Maybe you're using IE (which uses "class" attribute).
` is the "identifier" quote (for database names, tables, columns, aliases). It is not required unless the name is actually part of the SQL language (e.g. if you have a column named `group`, in most...
10-046 as INT is actually -36 (10 minus 046).
'10-046' as INT is 10 (string to num convertion is made by stopping at the first non-numeric character).
10-046 as CHAR is '-36'.
'10-046' as CHAR is...
Containing dashes means it's a string, not a number, which is no problem to be compared with another string of the same format (e.g. WHERE `string_id` = '10-046'). If you want to treat this as a...
I hope you don't mind if I post a link to your next thread about the code condensing (just to avoid splitting the discussion between both topics):
Display search results if they exist - trying to...
I'm assuming you have a table containing all the "1:00-10" etc. data (in the example I've named this table `mediadb` and the column is `mediadb1`). So, did you mean something like that:
That's because converting to number takes the left-most numeric characters until meeting the first non-numeric character (':' in this case), so actually "mediadb1 + 0" returns values of 1 and 2. Try...
And more easier would be to get an already written by somebody else vbscript than installing PHP only for a single task... Of course, if expecting to need additional scripts in future, then yes, PHP...
In your case batch commands wouldn't be powerful enough - you'd need to use another environment - Windows Script Host or another engine (PHP, for example) or even build yourself an .exe program using...
