ex.err "Sequence found inside character string"
Do the knowledgeable amongst us realize from looking at the small
CGI script that causes the subject message that you cannot include a value
containing a 'colon' in an EDB database as key or data info ???
(Also, as an aside..none of the \n codes in the 'puts' lines actually cause
a line break when displayed in the output page on the screen)
************** script ***************************************************
-- write records to the primary calendar table for the
upstate-ny-dance-calendar.com
-- web site
include database.e
integer i1
sequence key, newkey, data
newkey = {}
data = {}
key = {}
puts(1,"Content-type: text/html\n\n") -- this line is REQUIRED verbatim!
puts(1,"<html>")
puts(1,"<head>")
puts(1,"<title>" & "Create web site table" & "</title>")
puts(1,"</head>")
puts(1,"<body>")
i1 = db_open("upstatdc.edb", DB_LOCK_NO)
if i1 != DB_OK then
puts(1,"Could not open database\n")
puts(1, "</body></html>")
abort(1)
else
puts(1,"Opened upstatdc database\n")
end if
i1 = db_select_table("calendar")
if i1 != DB_OK then
puts(1,"Could not select table\n")
puts(1, "</body></html>")
abort(2)
else
puts(1,"Calendar table selected\n")
end if
key = append(key,{"2005-05-20","PM","09:00","Rockabilly Rays","Elmira","NY"})
data = append(data,{"Grand Central Avenue","607-760-0113","01:00",
"upstate-ny-dance-calendar.com","Come early"})
i1 = db_insert(key, data)
if i1 != DB_OK then
puts(1, "Insert to table failed\n") <----- this happens
puts(1, "</body></html>")
abort(3)
else
puts(1, "Record was written to database\n")
end if
newkey = db_record_key(1)
puts (1, "Returned first record key as: " & newkey)
puts(1, "</body></html>")
|
Not Categorized, Please Help
|
|
