[Pdns-users] no content

[Bob Lockie]

On 05/13/04 14:11 Dimitrij Hilt spoke:
> On Thu, May 13, 2004 at 01:54:55PM -0400, Bob Lockie wrote:
> 
>>On 05/12/04 22:01 Bob Lockie spoke:
>>
>>>>>>|  8 |         1 | www  | A    | 216.168.107.222 
>>>>>>                           | 3600 |    0 |        NULL |
>>>>
>>>>Hi,
>>>>
>>>>names in records must be FQDN, if you use standard queries from PowerDNS.
>>>>
>>>>basic-querie is:
>>>>select content,ttl,prio,type,domain_id,name from records where
>>>>type='%s' and name='%s';
>>>>
>>>>this querie will find ssh.lockie.ca type A but not ssh type A
>>>>
>>>>
>>>>Regards,
>>>>
>>>>Dimi
>>>
>>>
>>>Thank you very much.
>>>That was it.
>>
>>That was it for specific names (like xxx.lockie.ca) but it doesn't 
>>return the A record for just lockie.ca (no hostname).
> 
> FQDN from 'lockie.ca' is 'lockie.ca'
> insert into records values ('',1,'lockie.ca',A,'$IP',$TTL,'','') must
> works.

Thanks, I'll officially wear the idiot hat now. :-)
I had '' so I was doing it again.