Assuming then is required, the following 347 results were found.
to have IE 8 installed as my Windows browser (I wanted IE7 and the other 2 as standalones but apparently not possible) and then have IE6 and IE7 as separate browsers. If I was at home I'd just use Virtual PC with Windows7 but my customers are on XP and...
K2 Items disappearhttp://www.joellipman.com/articles/cms/joomla/k2-items-disappear.html
be able to run SQL commands against your database. My client had phpMyAdmin installed so I click on "jos_k2_items" table and then click on the "SQL" tab Type the following query: REPAIR TABLE jos_k2_items Note that I say "jos_k2_items" because by...
prospective tenant or even an employer will send you a cheque worth more than the value of the items/rent/job. They’ll then ask for the surplus money to be returned to them or a third party, for example ‘to pay for shipping’. The cheque will clear into...
{ while read line ; do match=$(echo "${line}" | egrep -o 'run-parts (-{1,2}\S+ )*\S+') if [[ -z "${match}" ]] ; then echo "${line}" else cron_fields=$(echo "${line}" | cut -f1-6 -d' ') cron_job_dir=$(echo "${match}" | awk '{print $NF}') if [[ -d...
This will be helpful because in my opinion, the simplest way to start using COM is to learn some basic JavaScript, and then "translate" that code to use with COM in AHK. COM - (Component Object Model) All you really need to know about COM for this...
"Student Reference" but not necessarily a student AD account (enquired/applied only). So following the above, I end up with: Then I want the ID parameter ("@StudentReference") to populate itself if it is left blank when the report is executed. So my...
The ReportServer Databasehttp://www.joellipman.com/articles/database/the-reportserver-database.html
unique ID of the report but not unique in the table (can be referenced many times). UserName nvarchar(260) NULL Windows authenticated username and domain of the person running the report (eg. MYDOMAIN\myusername) RequestType bit NOT NULL User or System....
database Change http://demo.joellipman.com/wordpress/ to the full URL of your WordPress site. If post_type is to be post then append with ?p= otherwise use ?page_id=. Articles: ------ MIGRATING JOOMLA v1.5.# CONTENT TO WORDPRESS v3.2.# ------...
page) / With 2 parameters provided in the main report (note: main report runs with incident number as NULL, the user can then add an incident number afterwards or when the initial report was run). The confirmation page just checks with the end-user that...
hassle of clicking on the big fat refresh button... Keeping It Simple Silly. So the suggestion of selecting all cells and then right-clicking and selecting "row height" is beyond us. We have since simplified this so that only the person who knows how to...
transfer users This is a free solution to at least get your user accounts all migrated. How you deal with the passwords can then be up to you. To use the following script, you need to change the my_wordpress_db to the name of your wordpress database and...
Updates a timestamp in an existing table Inserts a row into an audit table I need the report to run the stored procedure, then based on the errorlevel, return a message. How? We use a database account with read-only privileges to list all the details....
check the parameters submitted with a report for alpha numeric characters (so it doesn't contain symbols, punctuations, etc) then you should do this at the database level, and then get the report to complete the check: The Plan User enters value in...
loses connection or simply forgets what intranet site you were trying to access and your usual solution is a reboot, then this tool may be for you. In my environment, I am working with a Visual Studio 2008 IDE (Business Intelligence Development Studio -...
where student_ad_account = trim(lower(ad_username)); BEGIN open c1; fetch c1 into student_no; if c1%notfound then student_no := 0; end if; close c1; RETURN student_no; EXCEPTION WHEN OTHERS THEN raise_application_error(-20001,'An error was encountered -...
and without any warnings. So What? The problem is that if the student does not have a username but has an ID number, then the first query returns NO ROWS and then the second query errors and the whole stored procedure fails. The same problem happens...
checked_out_time, editor ) SELECT id, parent, CASE WHEN SUBSTRING(path, LOCATE(',', path)+1, LOCATE(',', path, 2))='' THEN 0 ELSE SUBSTRING(path, LOCATE(',', path)+1, LOCATE(',', path, 2)) END AS thread_id, path, level, object_id, object_group,...
IF THIS FIELD CONTAINS A DATE VALUE SET @DateMatch = CASE WHEN CAST(CAST(@OrigVal AS date) AS VARCHAR(10))'1900-01-01' THEN 1 ELSE 0 END; -- DETERMINE IF THIS FIELD CONTAINS A TIME VALUE SET @TimeMatch = CASE WHEN CAST(CAST(@OrigVal AS time) AS...
suggests the following (or at least the idea of): SELECT * INTO #MyTempTable FROM @GivenTable If @GivenTable is a parameter then the above will simply return an error. Also, if it was this easy, I wouldn't need to post this note on my website. Thinking...
the slides in from right to left with a transition. Push existing slide out to the left; as soon as this is out of sight then hide it behind the displayed slide. Replace contents of the hidden slide with contents of the displayed slide. Hide currently...