Click here to Skip to main content
15,915,078 members
Home / Discussions / Web Development
   

Web Development

 
Questionwhy getting: Uncaught ReferenceError: jQuery is not defined Pin
Jassim Rahma19-Nov-13 2:05
Jassim Rahma19-Nov-13 2:05 
QuestionProblem with dropdown button Pin
Jassim Rahma19-Nov-13 0:47
Jassim Rahma19-Nov-13 0:47 
SuggestionRe: Problem with dropdown button Pin
Richard Deeming19-Nov-13 2:21
mveRichard Deeming19-Nov-13 2:21 
Questionhow to open Profile manager on Windows Pin
TheSniper10518-Nov-13 2:43
professionalTheSniper10518-Nov-13 2:43 
AnswerRe: how to open Profile manager on Windows Pin
Richard Deeming18-Nov-13 2:50
mveRichard Deeming18-Nov-13 2:50 
GeneralRe: how to open Profile manager on Windows Pin
TheSniper10518-Nov-13 3:01
professionalTheSniper10518-Nov-13 3:01 
QuestionProblem with RewriteRule Pin
Jassim Rahma18-Nov-13 2:00
Jassim Rahma18-Nov-13 2:00 
Questionis that time to enable GZIP Compression? Pin
TheSniper10518-Nov-13 0:11
professionalTheSniper10518-Nov-13 0:11 
AnswerRe: is that time to enable GZIP Compression? Pin
Richard MacCutchan18-Nov-13 0:59
mveRichard MacCutchan18-Nov-13 0:59 
GeneralRe: is that time to enable GZIP Compression? Pin
TheSniper10518-Nov-13 2:11
professionalTheSniper10518-Nov-13 2:11 
GeneralRe: is that time to enable GZIP Compression? Pin
Richard MacCutchan18-Nov-13 2:20
mveRichard MacCutchan18-Nov-13 2:20 
GeneralRe: is that time to enable GZIP Compression? Pin
TheSniper10518-Nov-13 2:27
professionalTheSniper10518-Nov-13 2:27 
GeneralRe: is that time to enable GZIP Compression? Pin
Richard MacCutchan18-Nov-13 2:55
mveRichard MacCutchan18-Nov-13 2:55 
GeneralRe: is that time to enable GZIP Compression? Pin
TheSniper10518-Nov-13 2:57
professionalTheSniper10518-Nov-13 2:57 
AnswerRe: is that time to enable GZIP Compression? Pin
thatraja18-Nov-13 2:36
professionalthatraja18-Nov-13 2:36 
GeneralRe: is that time to enable GZIP Compression? Pin
TheSniper10518-Nov-13 2:46
professionalTheSniper10518-Nov-13 2:46 
AnswerRe: is that time to enable GZIP Compression? Pin
thatraja18-Nov-13 3:47
professionalthatraja18-Nov-13 3:47 
GeneralRe: is that time to enable GZIP Compression? Pin
TheSniper10518-Nov-13 5:23
professionalTheSniper10518-Nov-13 5:23 
QuestionRe: is that time to enable GZIP Compression? Pin
thatraja18-Nov-13 6:36
professionalthatraja18-Nov-13 6:36 
AnswerRe: is that time to enable GZIP Compression? Pin
TheSniper10519-Nov-13 0:16
professionalTheSniper10519-Nov-13 0:16 
Questionhow to connect the database of access on dreamweaver text box . Pin
Member 1040299717-Nov-13 19:27
Member 1040299717-Nov-13 19:27 
QuestionGuid in URL using htaccess Pin
Jassim Rahma15-Nov-13 23:36
Jassim Rahma15-Nov-13 23:36 
Questionbest database API for PHP Pin
Jassim Rahma15-Nov-13 6:18
Jassim Rahma15-Nov-13 6:18 
AnswerRe: best database API for PHP Pin
tgsb11-Dec-13 22:17
tgsb11-Dec-13 22:17 
QuestionSQL Server query with diacritics works in Studio but not in ADO query Pin
Member 223470915-Nov-13 0:47
Member 223470915-Nov-13 0:47 
I have a query which contains diacritics. The table being queried has fields set to NVarChar. The query is built up in a VBScript page, and is (somewhat simplified):
select l.id,l.comp,l.address3,l.address4 from log l where l.ID>0 and (address3 like N'Münster%' or address4 like N'Münster%')

The query works fine in SQL Server studio, but returns no rows when exactly the same query is sent through an ADO connection:

set rstemp=conn.execute(mySQL)

As far as I can work out, the problem is that the ü seems to be changed to something else - though not a u, because then it would return a record on the database that I'm using (if I change ü to u in the ADO search then I get that record returned).

If I put collate SQL_Latin1_General_CP1_CI_AI in the query:

select l.id,l.comp,l.address3,l.address4 from log l where l.ID>0 and (address3 collate SQL_Latin1_General_CP1_CI_AI like N'Münster%' or address4 collate SQL_Latin1_General_CP1_CI_AI like N'Münster%') and status <> N'DL' order by l.comp

then I get nothing returned, but if I use that query but with Münster changed to Munster then I get the records that I would expect.

Again, if I use these queries in SQL Server Studio then they do exactly what I would expect them to use.

How do I get the diacritics sent through the ADO query correctly, please?

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.