Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
French Characters
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 >... -
Roaming profiles - PLEASE help!!
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...- Decus
- Thread
- Replies: 1
- Forum: Microsoft: Windows servers
-
strange power problem
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...- Decus
- Thread
- Replies: 2
- Forum: PC hardware - General discussion
-
Help - SQL and table joins
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.- Decus
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Help - SQL and table joins
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- Decus
- Post #2
- Forum: Microsoft: Access Queries and JET SQL
-
Help - SQL and table joins
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...- Decus
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
-
Help - exiting Case Select statements
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.- Decus
- Post #9
- Forum: Microsoft: ASP (Active Server Pages)
-
Help - exiting Case Select statements
OK, thanks for your help anyway.- Decus
- Post #7
- Forum: Microsoft: ASP (Active Server Pages)
-
Help - exiting Case Select statements
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...- Decus
- Post #5
- Forum: Microsoft: ASP (Active Server Pages)
-
Help - exiting Case Select statements
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 "do something" code would only execute if y<>z - what about the other...- Decus
- Post #3
- Forum: Microsoft: ASP (Active Server Pages)
-
Help - exiting Case Select statements
Does anyone know how to prematurely exit a Case Select statement in ASP (not ASPX). I'm trying something like: Select Case x Case "one" 'check second condition If y=z Then Exit Case 'else do something Case "Two" 'do something Case...- Decus
- Thread
- Replies: 9
- Forum: Microsoft: ASP (Active Server Pages)
-
I have a date format problem - please help
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... -
I have a date format problem - please help
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 = "01/09/2003">... -
CFHTTP Problem
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... -
Using ColdFusion to check for dead links
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... -
MyCDONTSMail.Send
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="VBSCRIPT"%> <% Dim whorespond, strEmail, fname, lname, responsetocomments whorespond =...- Decus
- Post #2
- Forum: Microsoft: ASP (Active Server Pages)
-
ASP dead link checker
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?- Decus
- Thread
- Replies: 0
- Forum: Microsoft: ASP (Active Server Pages)
-
Using ColdFusion to check for dead links
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? -
Query Strings - reading string parameters
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. -
Query Strings - reading string parameters
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 = "English"> <cfoutput> <a href="mynextpage.cfm?subjectname=#subjectname#> #subjectname#</a> </cfoutput>...
