Another crazy thing Sqlit3 issues

[jvnorris]

OK I have a multiline text field that looks like

DESCRIPTION: 

STORE ACTIVITY: 
TIME PERIOD: 0 hours until open

blah blah blah

I can pull the thing nicely from the database but what I want to do is place a marker that after it is ran a variable would be entered

something like

DESCRIPTION: $Descinput

STORE ACTIVITY: 
TIME PERIOD: 0 hours until open

blah blah blah

where $Descinput would be data provided by the user.

I tired all manners of escaping the thing in the database and cant figure out what to put in the database itself to enable a variable that will be provided later.

Every time I run the query i just get back exactly what is in the database.

Is this even possible?

Please help

This is the sample of my query from the script

#include <SQLite.au3>
#include <SQLite.dll.au3>
$Database = "clientassist.s3db"
$temp = "'General'"
$Description = "Testing1234"
_SQLite_Startup()
_SQLite_Open($Database); open Database
_SQLite_Query(-1, "Select template from TEMPLATES where TemplateType = " & $temp & ";", $hQuery); the query
While _SQLite_FetchData($hQuery, $aRow) = $SQLITE_OK
    $_Queryresults &= $aRow[0]
;$_Queryresults &= "|"
WEnd
    _SQLite_Close()
    _SQLite_Shutdown()
MsgBox(0, "Test", $_Queryresults)

[PsaltyDS]

StringReplace() and then update the record?

$_Queryresults = StringReplace($_Queryresults, "DESCRIPTION: " & @CR, "DESCRIPTION: " & $Description & @CR, 1)

[jvnorris]

You are a god .. Thank you so much. Its not exactly want i wnated but it is an effective workaround