AltME: Databases

Messages

Chris
Erk, fixed a couple other dependencies, d'oh!

Endo
Very nice work Chris.  It would be nice to have that for MS-SQL too.
Chris
By the looks of it (I've not used MS SQL) it wouldn't be too different. Same for Sqlite. Just a matter of hacking http://reb4.me/r/mysql-schema to include the most appropriate datatypes.
Of course, that's only for the 'create statement. I imagine detecting differences in schemas between SQL dialects might be more nuanced. But then I haven't got that far with any dialect of SQL, so...

afsanehsamim
guys , i have one project (crossword )which uses mysql database! i want use mysql driver ,i know how  we can create table and make connectivity with database !  crossword should show on web page ,and when user put characters in each field ,then press button ,it will chek with database and if it is correct ,user can continue otherwise shows error message ....i created crossword table with cgi and is working on web ,i have created database as well,now my problem is i do not know how can i fetch data and comparing with database? is there anybody for helping my mini project????
i need only simple example of that ...plz help me if you can ... i do not have time :( ...i am very begginer in rebol
Arnold
Show what you have got so far, may be you are close.
afsanehsamim
my understanding of work steps is : i have two files *.cgi and *.r  ,in cgi file i created crossword that shows on web page ... in data.r  i have made connectivity with database and create table ... and my codes are as following : in cgi file:
#! "C:/wamp/bin/apache/Apache2.2.11/cgi-bin/rebol-core-278-3-1.exe" -cs
REBOL [Title: "Table"]
print "content-type: text/html^/"
print [<HTML><BODY><TABLE  bgcolor="black" border="1">
{
<tr bgcolor="white">
<td style="width:30px; height:30px;"><input name="one-one" type="text" size="1"></td>
<td style="width:30px; height:30px;"><input name="one-two" type="text" size="1"></td>
<td style="width:30px; height:30px;"><input name="one-three" type="text" size="1"></td>
</tr>
<tr bgcolor="white">
<td style="width:30px; height:30px;"><input name="two-one" type="text" size="1"></td>
<td style="background:black; width:30px; heigth:30px;" ></td>
<td style="width:30px; height:30px;"><input name="two-three" type="text" size="1"></td>
</tr>
<tr bgcolor="white">
<td style="width:30px; height:30px;"><input name="three-one" type="text" size="1"></td>
<td style="width:30px; height:30px;"><input name="three-two" type="text" size="1"></td>
<td style="width:30px; height:30px;"><input name="three-three" type="text" size="1"></td>
</tr>
}
]
print [</TABLE></BODY></HTML>]
and my data.r codes :
#! "C:/wamp/bin/apache/Apache2.2.11/cgi-bin/rebol-core-278-3-1.exe" -cs
REBOL [Title: "Table"]
print "content-type: text/html^/"
print [<HTML><BODY><TABLE  bgcolor="black" border="1">
{
<tr bgcolor="white">
<td style="width:30px; height:30px;"><input name="one-one" type="text" size="1"></td>
<td style="width:30px; height:30px;"><input name="one-two" type="text" size="1"></td>
<td style="width:30px; height:30px;"><input name="one-three" type="text" size="1"></td>
</tr>
<tr bgcolor="white">
<td style="width:30px; height:30px;"><input name="two-one" type="text" size="1"></td>
<td style="background:black; width:30px; heigth:30px;" ></td>
<td style="width:30px; height:30px;"><input name="two-three" type="text" size="1"></td>
</tr>
<tr bgcolor="white">
<td style="width:30px; height:30px;"><input name="three-one" type="text" size="1"></td>
<td style="width:30px; height:30px;"><input name="three-two" type="text" size="1"></td>
<td style="width:30px; height:30px;"><input name="three-three" type="text" size="1"></td>
</tr>
}
]
print [</TABLE></BODY></HTML>]
sorryyyy
this codes:
REBOL []
do %mysql-protocol.r
db: open mysql://root@localhost/test
insert db {create table data (
    name            varchar(100),
    address         text
  )}
insert db {INSERT into data VALUES
    ('raj', 'pune'),
    ('ekta', 'delhi'),
    ('ankur', 'mumbai')
    
}
insert db "SELECT * from data"
results: copy db
probe results
close db
the second file is only exaple of connectivity
table is differenet
Arnold
what did the probe results show?
afsanehsamim
in rebol interpreter only created table
i mean when i run data.r it creats table
i do not know how should i mix cgi file with database file
the results is like this:
do %data.r
Script: "Untitled" (none)
Script: "MySQL Protocol" (12-Jul-2008)
MySQL protocol loaded
connecting to: localhost
[
    ["raj" "pune"]
    ["ekta" "delhi"]
    ["ankur" "mumbai"]
]

Last message posted 95 weeks ago.