E.K.Virtanam,

The RSS option has been enabled since I converted from phpBB.

Thanks for the link to show folks how it is used. I'll try and add a RSS mod to display a button/symbol or add one myself for all board activity.


John

ScriptBasic Windows 2.1 RC1 has been released.

Release Notes - Armando Rivera

• Full release includes pre-built binaries, source and documentation
• All modules except the hash module seem to be working.
• Berkeley DB is original pre-compiled extension module that Peter Verhas released.

** Scriptbasic Updated 3rd Party Module Support **

-- 2009-09-06 AIR --
The following Modules have been updated to use newer versions
of 3rd party libararies:

 ----------------------------------------
| MODULE      LIBRARY VERSION       |
 ----------------------------------------
   GD      2.0.35
   CURL      7.19.5
   MYSQL   6.0.2(CONNECTOR)
   XML      2.7.3
   PSQL      8.4.0-1
   ZLIB      1.2.3
   
Import Libraries and Includes for the above are located
in the Module_Support folder.

The entire package has been rebuilt using VC++9.  Version 7 is the minimum
required version for compiling from source.

Please read the license.txt file for general licencing terms.

The 3rd party libraries may be governed by different licencing.  Please read
their licencing terms when you download each library from the provider.

AIR.

It couldn't be a better time to start using open source software. A client is more willing to expand the scope of a project and not be so price conscious when the software they will be using is free. The budget for the project is used to pay for your services and on going support. You remove the risk and give the feeling that life can go on if you or your company doesn't. It's much harder to get a client to take on new projects these days not knowing what the ROI may be. With open source software you can provide solutions that are already available which you can use as is or integrate into your custom solutions. You can be more competitive against larger commercial solutions because you have the open source community behind you covering your back. Linux and the many php based offerings are proof the concept works.

It's all about using shared resources and creating a community of users/VARS that take ownership into the software they use. Open  source software in general is more secure, better written and supported. The more eyes your have looking at the code the more stable it will be. Contribute your time to projects you plan to use to solve your clients needs.

Sorry for taking so long to notice this request.

Here is the online docs for the NT extension module.

http://www.scriptbasic.org/docs/nt/mod_nt_toc.html


I found a VBScript registry search that may work as a foundation for your application.

'RegSrch.vbs - Search Registry for input string and display results.
'© Bill James - wgjames@mvps.org
' revised 20 Apr 2001 (parses regfile ~3X faster)
' revised 13 Dec 2001 (added Regedit command line switch for Win2K/WindXP)

Option Explicit
Dim oWS : Set oWS = CreateObject("WScript.Shell")
Dim oFSO : Set oFSO = CreateObject("Scripting.FileSystemObject")

Dim sSearchFor
sSearchFor = InputBox("This script will search your Registry and find all " & _
             "instances of the search string you input."  & vbcrlf & vbcrlf & _
             "This search could take several minutes, so please be patient." & _
             vbcrlf & vbcrlf & "Enter search string (case insensitive) and " & _
             "click OK...", WScript.ScriptName & " " & Chr(169) & " Bill James")

If sSearchFor = "" Then Cleanup()

Dim StartTime : StartTime = Timer

Dim sRegTmp, sOutTmp, eRegLine, iCnt, sRegKey, aRegFileLines

sRegTmp = oWS.Environment("Process")("Temp") & "\RegTmp.tmp "
sOutTmp = oWS.Environment("Process")("Temp") & "\sOutTmp" & _
          Hour(Now) & Minute(Now) & Second(Now) & ".tmp "

oWS.Run "regedit /e /a " & sRegTmp, , True '/a enables export as Ansi for WinXP

With oFSO.OpenTextFile(sOutTmp, 8, True)
  .WriteLine("REGEDIT4" & vbcrlf & "; " & WScript.ScriptName & " " & _
    Chr(169) & " Bill James" & vbcrlf & vbcrlf & "; Registry search " & _
    "results for string " & Chr(34) & sSearchFor & Chr(34) & " " & Now & _
    vbcrlf & vbcrlf & "; NOTE: This file will be deleted when you close " & _
    "WordPad." & vbcrlf & "; You must manually save this file to a new " & _
    "location if you want to refer to it again later." & vbcrlf & "; (If " & _
    "you save the file with a .reg extension, you can use it to restore " & _
    "any Registry changes you make to these values.)" & vbcrlf)

  With oFSO.GetFile(sRegTmp)
    aRegFileLines = Split(.OpenAsTextStream(1, 0).Read(.Size), vbcrlf)
  End With

  oFSO.DeleteFile(sRegTmp)

  For Each eRegLine in aRegFileLines
    If InStr(1, eRegLine, "[", 1) > 0 Then sRegKey = eRegLine
    If InStr(1, eRegLine, sSearchFor, 1) >  0 Then
      If sRegKey <> eRegLine Then
        .WriteLine(vbcrlf & sRegKey) & vbcrlf & eRegLine
      Else
        .WriteLine(vbcrlf & sRegKey)
      End If
      iCnt = iCnt + 1
    End If
  Next

  Erase aRegFileLines

  If iCnt < 1 Then
    oWS.Popup "Search completed in " & FormatNumber(Timer - StartTime, 0) & " seconds." & _
              vbcrlf & vbcrlf & "No instances of " & chr(34) & sSearchFor & chr(34) & _
              " found.",, WScript.ScriptName & " " & Chr(169) & " Bill James", 4096
    .Close
    oFSO.DeleteFile(sOutTmp)
    Cleanup()
  End If
  .Close

End With

oWS.Popup "Search completed in " & FormatNumber(Timer - StartTime, 0) & " seconds." & _
          vbcrlf & vbcrlf & iCnt & " instances of " & chr(34) & sSearchFor & chr(34) & _
          " found." & vbcrlf & vbcrlf & "Click OK to open Results in WordPad.",, _
          WScript.ScriptName & " " & Chr(169) & " Bill James", 4096

oWS.Run "WordPad " & sOutTmp, 3, True

oFSO.DeleteFile(sOutTmp)

Cleanup()

Sub Cleanup()
  Set oWS = Nothing
  Set oFSO = Nothing
  WScript.Quit
End Sub


Welcome to the ScriptBasic project EfSeven.

I will try to help if you can provide a bit more information.

I assume your using ScriptBasic for Windows based on your DLL comment.

ScriptBasic provides a set of working binaries / libs  you can obtain from this site.

If your interested in using ScriptBasic as a scripting engine for your own application then the following developer documentation may be of help.

http://www.scriptbasic.org/docs/dg/devguide_toc.html

Look at section three, "Embedding the Interpreter" for more info.


John

Hint:


mysql::query(dbh, SQL)

In your example you assign the variable SQL with the statement but that's it.

Now MySQL needs to process it with the query() function.

Nothing to fetch() as your not requesting a return of any data.

If the row already exists and has a unique 'key' (index) then you would get an error on the INSERT and would have to use a UPDATE instead.

You have an error in your SQL string as well.


SQL = "INSERT INTO contact (NAME) VALUES (" & TEXT-FIELD")"

should be:

SQL = "INSERT INTO contact (NAME) VALUES ('" & cgi::PostParam("TEXT-FIELD") & "')"


John

JK,

Welcome to the ScriptBasic forum.

Here is an example of using the MySQL extension module in a CGI environment.

http://www.scriptbasic.org/forum/index.php/topic,3.0.html

To "write" to a SQL database you have to use the INSERT or UPDATE SQL statements.

Let us know how it works out for you.

John