Search results for query: *

Hi, I'm having a problem with french characters when performing a database dump from the console window on a Windows XP machine. For example a field containing :Midi-Pyrénées will appear as Midi-Pyr‚n‚es when exported. mysqldump -u root -p mydb --default-character-set=utf8 >...

If I'm logged into the domain, via the XP pro, under a user with full admin rights and I go to control panel >> System >> Advanced >> Settings (User profiles) I have two accounts: 1) the local system admin account and 2) the domain 'SANTA' user account that also has local machine admin rights...

Hi, I'm experiencing some odd behaviours with my PC powering up and and down: Powering up The computer needs to beed turned off completely from the switch at the rear. When turned on again from this switch, no matter how long after the system was shut down, the fans automatically come on...

Problem solved (or not solved) - it was working fine anyway. Unfortunately there was an incorrect record in the RelatedBooks table which was giving me improper results.

OK, I know why I'm getting duplicate results - I needed to specify an addition condition in the WHERE clause, but I'm still having problems with receiving records from the RelatedBooks table where they match up with books in the Books table

I have two tables, Books and RelatedBooks , with identical field names, title and author The RelatedBooks has records that related to the table Books, but not all Books have related books. I want a list of all books from both the Books table and RelatedBooks table when I specify a criteria...

Very good suggestion Tarwn. It's a shame there's no "Exit Select" statements for prior .net VB code but your hack is the next best thing. Thanks.

OK, thanks for your help anyway.

Sorry, you're quite right in one aspect, it was a bad example I provided. But for more complex scenarios I believe there is a need for such a command when prematurely existing a Case Select statement is necessary/helpful. It seems that I'm not the only one who thinks this, if you look on...

sorry but I should have said that I'm aware that I could use If statements but also your answer would be incorrect if there were other reasons to execute the code If y<>z Then 'do something END IF The &quot;do something&quot; code would only execute if y<>z - what about the other...

Does anyone know how to prematurely exit a Case Select statement in ASP (not ASPX). I'm trying something like: Select Case x Case &quot;one&quot; 'check second condition If y=z Then Exit Case 'else do something Case &quot;Two&quot; 'do something Case...

Thanks arperry and r937 for your input. Using createODBCdate(thedate) inside the sql INSERT command (without single quotes around it) seems to have solved the problem for storing the date on the SQL Server, and CONVERT(char(10),expirydate,103) has helped to convert the date to dd/mm/yyyy format...

The Problem: When I insert dates in SQL Server 2000 into a field having a data type 'datetime', the date is recorded in US format even though I had specified a european format, e.g., 01/09/2002 gets recorded in the database as 09/01/2002. The Code: <cfset thedate = &quot;01/09/2003&quot;>...

I'm fairly new to ColdFusion and especially using the CFHTTP tag. Here's the problem: We have a database storing over 3000 links (and increasing) to various web sites. What we want to do is create an automatic link checker that will probe each link stored in the database to test whether they're...

Cheers cfwoohoo, Your response sounds very encouraging. However, I'm fairly new to CF, so which of the two possibilities you mentioned would you consider the easiest/most accurate solution and could you provide any pointers of how to achieve this - if this is too troublesome then don't worry...

I've checked your code and it works OK provided that you supply values for the variables. Below is your code that I slightly changed, in which I received an email after running it. <%@LANGUAGE=&quot;VBSCRIPT&quot;%> <% Dim whorespond, strEmail, fname, lname, responsetocomments whorespond =...

Does anybody know if it is possible to write a ASP script that could check for dead links externally and internally to the web server. I know this can be done in PERL but can it be done in ASP?

Does anybody know if it is possible to write a coldfusion script that could check for dead links externally and internally to the web server. I know this can be done in PERL but can it be done in CF?

Problem solved. It wasn't the code but ftp problems. ftp client did not overwrite previous code which included the statement #val(url.subjectname)# hence why the returned value of zero.

Hi, I'm a newbie to coldfusion. What I'm trying to acieve is send a string parameter in a url and have the next page read the value. myfirstpage.cfm <cfset subjectname = &quot;English&quot;> <cfoutput> <a href=&quot;mynextpage.cfm?subjectname=#subjectname#> #subjectname#</a> </cfoutput>...