View Single Post
  #120 (permalink)  
Old 11-02-2008, 06:05 AM
tsteward tsteward is offline
Basic4ppc Veteran
 
Join Date: Apr 2008
Location: Gosford NSW Australia
Posts: 223
Send a message via MSN to tsteward
Default

Its been almost a month since the last update. I have really been struggling but finally achieved adding the ability to search SQL Light databases from within the wiki.
I think this makes this a very powerful program. And if not well it suits my needs I LOVE IT.

A simple line
[@sql?databaseName?SQLCommand@]
will search your database and display the results in a table anywhere in your page

Alternately
[@sqlsearch?databaseName?SQLCommand@]
will display a form for you to get data from the user to search for.
NOTE: you must put "clientInput" into your command. This represents what the user typed into the form.
E.G:
Code:
[@sqlsearch?keyconv?SELECT * FROM Keys WHERE Silca LIKE '%clientInput%'@]
This will open database "keyconv" and display all fields where field "Silca" is like the users input.

PPC Version 0.78
  • Started modularizing code
  • Added variable to global s to contain extensions that when linked to ppcw will shell out. which means you can resize an image but link to that image to view it larger.
  • Added SQL Search ability
PC Version 0.78
  • Started modularizing code
  • Added variable to globals to contain extensions that when linked to ppcw will shell out. which means you can resize an image but link to that image to view it larger.
  • Fixed removed file path when creating contents list.
  • Added SQL Search ability
__________________
PC: Dual core 3.4ghz 2gb ram
PPC: I-mate Jasjam

Last edited by tsteward : 11-02-2008 at 06:08 AM.
Reply With Quote