Welcome, Guest
Username: Password: Remember me
Forgot your password? Forgot your username? Create an account
Forum
Debug
Closed tickets.
[FIXED] Database Name Quote and Value Quote
  • Page:
  • 1

TOPIC:

Database Name Quote and Value Quote 03 Oct 2011 17:48 #89

MySQL uses backticks `` for names and single quotes ‘‘ for values. On the generated component I got form Cook, I noticed that the databases does not have any quote at all.

There is a recommended way to work with this situation, by adding $db->nameQuote($name) to embrace names or values... a database query would be like this:
$query = "
  SELECT * 
    FROM ".$db->nameQuote('#__example_table')."  
    WHERE ".$db->nameQuote('id')." = ".$db->quote('999999').";
  ";

I think this would be a good thing to be added to follow the standards and avoid compatibility issues...
Paulo Griiettner
The following user(s) said Thank You: admin

Please Log in or Create an account to join the conversation.

Re: Database Name Quote and Value Quote 05 Oct 2011 12:51 #103

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 986
You are right.

Sometimes, we used hard writed `, but never with the native function as you describe.

We will make a global check on this.
Coding is now a piece of cake

Please Log in or Create an account to join the conversation.
  • Page:
  • 1
Forum
Debug
Closed tickets.
[FIXED] Database Name Quote and Value Quote
Time to create page: 0.077 seconds
“
”

I jumped and started to work on a demo component... but 2 days later this demo component became the real component. I just showed today the end result to my customer and he turned to me and said... "this is more than I expected"... All of this is because Cook did cut about 70% of my work and provided me more ways to improve the usability of the component. The end result was 17 tables all related between than to generate a full dashboard for the travel agents. Thanks for Cook developers for such great tool. This component would not be possible to be done at short time with all the features in it
Griiettner (Forum)  

Get Started

Log In Sign In