I don't remember what I did, or didn't do, with the Matrix stuff. Please send it, or a link, to my email so I can look at it first. I know there are some things that might be still good... and some pointless junk. ;)
aaron@minervaai.com
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
Show posts Menu
oldEntry = "6:00PM"
newEntry = "6:30PM"
HalBrain.RunQuery("UPDATE mainQA SET timestamp = " + newEntry + " WHERE UPPER(timestamp) LIKE UPPER('" + oldEntry + "')", returnArray)
Quote
if I was to assign a string variable to Elvis Presley, what would your example above look like using a string variable?
Quote
the 2nd thing is:
if I am understanding you correctly, the command { UPPER(Question) } indicates the column that you want to look in.
So if I wanted to look in answer the command would be { UPPER(Answer) } ?
Quote
what is the easiest way to divide the words in a sentence?
array1 = Split("a chick can run fast", " ", -1, vbTextCompare)
array1(0) ' = a
array1(1) ' = chick
array1(2) ' = can
array1(3) ' = run
array1(4) ' = fast
array2 = Split("a##dog##can##run##faster", "##", -1, vbTextCompare)
array2(0) ' = a
array2(1) ' = dog
array2(2) ' = can
array2(3) ' = run
array2(4) ' = faster
ynlogic0 = "Fred is my friend. Who is Fred?"
array3 = Split("Fred is my friend. Who is Fred?", ".", -1, vbTextCompare)
If Ubound(array3) = 2 Then
ynlogic1 = array3(0)
ynlogic2 = array3(1)
End If
Quote
But my question is: can this command structure be used to search through: for instance in your example: { Dim returnArray() }
If InStr(1, UserSentence, "please test this plugin two", vbTextCompare) > 0 Then
Dim returnArray()
fline = ""
If HalBrain.RunQuery("SELECT Question FROM mainQA WHERE UPPER(Question) LIKE UPPER('%WORK%') OR UPPER(Question) LIKE UPPER('%DOES%') ", returnArray) = True Then
For i = 0 To UBound(returnArray)
fline = fline + returnArray(i , 0) + " | "
Next
GetResponse = fline
Else
GetResponse = "Yes, this has been done."
End If
End If