• Home
  • Script library
  • AltME Archive
  • Mailing list
  • Articles Index
  • Site search
 

AltME groups: search

Help · search scripts · search articles · search mailing list

results summary

worldhits
r4wp55
r3wp797
total:852

results window for this page: [start: 56 end: 155]

world-name: r3wp

Group: All ... except covered in other channels [web-public]
Ammon:
29-Dec-2004
That's sad because I know the guy that owns the place and I KNOW 
he isn't going to replace the drywall. Whoever moved in/will move 
there is undoubtedly have some trouble with it.
Group: !AltME ... Discussion about AltME [web-public]
[unknown: 9]:
10-Mar-2005
We plan to clean it up, and write a paper that explains it all, for 
example, you can actually dump all your grpahics, and then replace 
them all.
BrianH:
15-Jul-2005
replace "me" "my"
[unknown: 9]:
20-Jul-2006
The funny thing is……………….


I run several AltME worlds on several computers(Mac, PC).  All my 
computers in a given day move from wired to wireless.  Not just that, 
but I go from a wired home to a wireless home (if I have to save 
big files I plug the wire in).  I then gt in my truck where I jump 
to Sprint Cell PCMCI card (about 70K bytes per second).  Which I 
use to talk to people on Skype.  In my office I pick up the local 
wireless, and bring up a second copy of AltME on a second laptop.


With all that, not once in all these years have I lost even a single 
message in AltME, not been able to log in, etc.  Obviously there 
have been a couple of Server outages, but I'm not even near the servers, 
and I have never even had trouble from Maui.


It is odd.  The sad reality is that a strong percentage of problems 
are simply the local computer.  Even if it is "only" AltME (or replace 
with any other application) you are having trouble with.
Group: RAMBO ... The REBOL bug and enhancement database [web-public]
Anton:
10-Feb-2005
Gosh! now I think it might be better to replace the "?" with a slash 
"_query/"  (<-- note the slash), so it becomes a new directory.
Anton:
10-Feb-2005
Mmm.. similar to Oldes' method, you could replace "?" -> "_query/", 
  then directories that end with "_query/" are converted back to 
"?"
Brett:
19-May-2005
test-address-import: func [

 {Returns true if pass, false if discrepency and none if failed with 
 error.}
	limit [integer!] "Number of TO address to generate."
	/quiet "Does not display error."
	/local to-list eml sep msg obj
] [
	to-list: copy {} sep: ""
	repeat i limit [
		eml: to-email join "test-" [i "@test.com"]
		repend to-list [sep {"'} eml {'" <} eml {>}]
		if empty? sep [sep: {,^/	}]
	]

	msg: replace copy {Date: Thu, 12 Feb 2004 11:41:49 +0100
From: test <[test-:-test-:-com]>
MIME-Version: 1.0
To: TO_LIST
Subject: [REBOL] test message - edited copy of real message
Content-type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 8bit
Sender: [rebol-bounce-:-rebol-:-com]
Reply-to: [testing-:-testing-:-com]
Status:   


Test message.
} {TO_LIST} to-list

	either error? set/any 'result try [
		obj: import-email msg
		limit = length? obj/to
	][if not quiet [print mold disarm result] none][result]

]
Group: Core ... Discuss core issues [web-public]
Ladislav:
7-Jan-2005
your trouble is, that the evaluation of X doesn't have the same effect 
as if you replace X by its value. The evaluation of X only yields 
a set-word instead of setting anything. If you really want to set 
a word 'y, then there are two ways:

set x 'z

do compose [(x) 'z]
Geomol:
22-Jan-2005
Did I just found an error with replace? Try these:
>> replace/all "abc{def" "{" "^^{"
== "abc^^{def"
>> replace/all "abc{def" "{" "^{"
== "abc{def"

So I can't get a result with just one ^?
Geomol:
22-Jan-2005
>> replace/all "abc{def" "{" "^^^{"
== "abc^^{def"
Volker:
22-Jan-2005
print replace/all "abc{def" "{" "^^^{"
Chris:
31-Jan-2005
dehex?  (preceded by replace/all text "+" " ")
Micha:
16-Mar-2005
;serwer proxy


p: make port! tcp://:80

p/awake: func [ port /local  data conn targed cmd partner url 
] [



conn: first port
wait conn
data: to-string copy conn

replace/all data "^M" ""
source data

targed: copy/part data find data "HTTP/1.1"
data: find/tail data "^/"
print targed

cmd: parse targed none

url:  decode-url cmd/2 

if not url/path  [url/path: "" ]

if not url/target  [url/target: ""]

partner: open/no-wait to-url rejoin [ "tcp://" url/host ":80" ]




insert partner rejoin [ cmd/1" /" url/path url/target " HTTP/1.1^/" 
 data]

wait partner

tmp: copy partner




close partner



insert conn tmp



close conn 

]


append system/ports/wait-list p


open/binary/no-wait p
 wait []


halt
Ashley:
2-May-2005
replace/all blk integer! 0
Sunanda:
2-May-2005
Thanks!

That works only if they _are_ all integers.....But that's easily 
fixed:
     replace/all blk any-type! 0
Gabriele:
2-May-2005
replace is mezzanine, so change/dup is going to be faster; also, 
replace is going to be much slower than the simple loop you could 
use to do what replace is doing in this specific case.
Gabriele:
2-May-2005
(compare that to the source of replace)
Brock:
4-May-2005
mention in...  parse test ...you should replace test with your d 
word.
Sunanda:
6-Jun-2005
And it works the same way as replace or uppercase -- directly on 
the data.
Guest:
11-Jun-2005
Hello.  I was wondering how to replace a quotation mark in a string.. 
like this.
x: 'this " one'
replace x '"' ""

??
ChristianE:
11-Jun-2005
replace/all {A"B"C} {"} "'"
Ingo:
25-Jul-2005
Q1: I want to replace all 'none in a block with _different_ empty 
strings, what's the fastest way to do this?

(replace/all BLOCK none ""       replaces all 'none with the same 
empty string)
Ingo:
25-Jul-2005
PS. Do you, like me, feel that the replace way of doing things is 
questionable?
Brett:
26-Jul-2005
; Q1: copy/deep will give you new strings:
block: [none none none]
new-block: copy/deep replace/all block 'none {}
Brett:
26-Jul-2005
But if you do need to do an actual replace on the original block 
- see the other solutions :-)
Henrik:
6-Aug-2005
a one liner I didn't see on rebol.com: Sum of all numbers in a block!:

do do replace/all mold [1 2 3 4 5] " " " + "
Sunanda:
7-Aug-2005
Clever!
But crucially dependent on the block being contained on one line:
 xx: {
 do do replace/all mold [1 2 3
  4 5] " " " + "
 }
 do xx

But then you did call it a one-liner :-)
Group: Script Library ... REBOL.org: Script library and Mailing list archive [web-public]
Anton:
10-Feb-2005
Could add/replace some of that with "cross-platform, CGI, console 
and simple GUI dialect etc.."
Sunanda:
11-Feb-2005
Thank guys

Ammon -- control panel  --- can you do a mockup to show what you 
are thinking?

Banner text -- this is a good place for that dicsussion.....REBOL.org 
could publish the winners and use one/some of them to replace the 
existing banner tex.
eFishAnt:
25-Apr-2006
there were some others.  I contacted TGD to get one that saves...hope 
they have done more with it...but there were some...gonna search 
my harddrive.  course, what I want to do can just be a one-line replace...just 
wanna get a good tool for hex crafted as I need.  I started on one 
a while back...
Group: I'm new ... Ask any question, and a helpful person will try to answer. [web-public]
Henrik:
13-Apr-2006
probably through old fashioned search/replace
Anton:
17-Apr-2006
Now, the tricky thing with modifying parts of a string in a parse 
rule is that you have to leave the current parse index at the end 
of your new replacement string.

What usually happens is you parse up to your search string, set a 
marker (here it's done with p1:), parse through your search string, 
set another marker (p2:), then

 	(remove/part p1 p2
	insert p1 "my new string")


but if the the new string is shorter or longer than the old string, 
then the parse index will be left in the wrong position.

So to fix that we need to set p2 to p1 plus the length of the new 
string, then set the parse index to that position so it can continue 
as intended:

	(p2: p1 + length? new-string) :p2


So the full example above can modify links in place if you simply 
replace:

	(append images copy/part p1 p2)

with something like:

 	(
		old-string: copy/part p1 p2
		new-string: "create your new link from the old one here"
		remove/part p1 p2
		insert p1 new-string
		p2: p1 + length? new-string
	) :p2
Group: Parse ... Discussion of PARSE dialect [web-public]
Sunanda:
22-Aug-2005
One way:
   replace text "*" <strong>
   replace text "*" </strong>

If there are multiple pairs of "*", repeat in a loop until the length 
no longer changes
Volker:
1-Mar-2006
replace/all str "," comma " ; :))
Volker:
1-Mar-2006
But chars like # are easier to search/replace. But i dont defend 
my solution, yours looks ok.
Do you write your dialect-code in rebol-blocks or in a string?
Rebolek:
1-Mar-2006
Volker this is some special case, you can replace that before parsing 
string, but you cannot replace all commas in action script, some 
of them may be parts of string
Group: MySQL ... [web-public]
DideC:
25-Feb-2005
I could use the REPLACE statement, but doc said that it's an heavy 
instruction.
Is there an "UPDATE-IF-THERE-ELSE-INSERT" statement somewhere ?
Dockimbel:
11-Jun-2006
Erratum: replace the step : do %mysql.r by :
Group: Syllable ... The free desktop and server operating system family [web-public]
Volker:
3-Sep-2005
No, but you can replace it with a x86-compiler. bigforth has one.
Kaj:
14-Nov-2005
Yes, it's primitive. It should be replaced with a native graphical 
installer, maybe with Orca scripting embedded. It just hasn't been 
a priority yet. We were pretty pleased a few years ago to replace 
the manual installation with a text installer :-)
Group: Linux ... [web-public] group for linux REBOL users
Graham:
27-Jan-2006
Volker is suggesting this:

escape-metachars: func["escape metachars" s][
 replace/all s "'" "''"
 rejoin ["'" s "'"]
]

browse: func[url]compose/deep[

call rejoin ["screen -X screen -- " (view-root/bin/browser.sh) " 
" escape-metachars url]
]
Anton:
18-Dec-2006
replace/all select req-file/start-out [out: layout] 'slider 'scroller
DanielSz:
13-Sep-2007
I'm looking to replace my mailer (The Bat! on windows) to a linux 
solution for ubuntu. what would you guys recommend? Claws? Evolution? 
Sunbird? Or something like mutt or pine? Or even some emacs solution? 
What do you think?
Graham:
30-Mar-2008
If I wish to upgrade/replace the binary I am currently running, and 
I am running it from a symlink, can I just overwrite the target file?
Group: CGI ... web server issues [web-public]
Volker:
19-Aug-2005
prepare your upload with rebol and replace some things server-specific.

  write %dst/cgi/script.r join "#!/here/is/rebol^/" read src/script.r
Ingo:
23-Aug-2005
Does anyone have exoerience with CMS's with Rebol cgi? How do they 
scale compared to the usual suspects? (the three "P"s Perl/Python/Php) 
(Maybe that's the biggest hurdle to worldwide Rebol adoption: it 
doesn't start with a "P" so can't easily replace any of the aforementioned 
languages in the LAMP acronym ... Any chances of renaming Rebol to 
Pebol?)
Gabriele:
28-Sep-2006
afaik, the latest formmail.pl is "secure enough" (esp. if you configure 
it properly). it's not the best system out there, and being very 
popular it is also a popular target, but if you don't have time to 
replace it but can keep it up to date you should be fine.
Group: Web ... Everything web development related [web-public]
Sunanda:
31-Jan-2005
The biggest advatnage you'll find in workflow is when the client 
starts making changes.


1000 pages all with <font color=blue> and they now want all <p>s 
to be green -- that's not a search and replace job -- you need to 
check the context of each <font> tag.. It might take hours. Next 
day, they ask for dark yellow.
In css:

p {color:blue} -- you can show them the whole site changed in 1 minute.


Though, of course, you need to think through the styles you need 
first. That's a big bit of the design.
Group: !RebGUI ... A lightweight alternative to VID [web-public]
Ammon:
31-Mar-2005
Well, from my POV...  Carl intended to have us build dialects that 
are better than VID.  There have been several attempts so far but 
none of them have made it far enough to actually be ready for mainstream 
usage.  I think that if we can actually produce a solid dialect that 
outperforms VID in enough areas then Carl will want to add it to 
the language or maybe even replace VID with it.
shadwolf:
30-Apr-2005
I think I replace the feel/engage for  check ...
shadwolf:
30-Apr-2005
I replace it with the selection code
Group: XML ... xml related conversations [web-public]
BrianH:
30-Oct-2005
You might even be able to replace attribute value strings with REBOL 
values if you implement XML Schema typing.
CarstenK:
7-Nov-2005
I will try the new xml2rebxml.r, I think it would be nice to preserve 
the comments. If somebody writes xml in a text editor and makes some 
annotations, so it its nice, if he gets these comments back after 
processing the files with some other (REBOL) tool. But this feature 
has some lower priority.
I found some more thing in xml2rebxml.r, only the entities
      replace/all att-data "&gt;" #">"
      replace/all att-data "&lt;" #"<"
      replace/all att-data "&amp;" #"&"
will be replaced,  the other two are missed, I think:
      replace/all att-data "&quot;" #"^""
      replace/all att-data "&apos;" #"'"
Christophe:
7-Nov-2005
MichaelB: about unicode handling. That's a point we didn't think 
about, because we're working in iso-8859-1 (western european) and 
not utf-8 or-16. So we've to see what would the cost be of it. If 
here is any suggestion about how to handle this, those are mostly 
welcome ! (I handled a similar problem with a simple replace/all, 
but i don't know if it's the best approach)
About a port-approach... What should be the advantages ?
Gabriele:
28-Apr-2006
no, you specify a pattern that can match a subtree, and replace that 
subtree with something else.
BrianH:
29-Apr-2006
You can do some structural pattern matching with parse rules, but 
with how parse is currently implemented it can be a little awkward. 
The lack of arguments to parse rules make recursion quite difficult, 
and the lack of local variables make the rules difficult to use concurrently. 
It is difficult to examine both the data type and the value of elements 
in block parsing, to switch to string parsing mode for string elements, 
to parse lists, hashes or parens, to direct the parse flow based 
on semantic criteria (which is needed to work around any of these 
other problems).


And don't even get me started on the difficulties of structure rebuilding. 
The thing that is the most difficult to do in parse is the easiest 
thing to do with regexes: Search and replace. Didn't we make a web 
site years ago collecting suggestions for improving parse? Wasn't 
a replace operation one of those suggestions? What happened with 
that?


Structural pattern matching and rebuilding currently has to be done 
with a mix of parse and REBOL code that is tricky to write and debug. 
If parse doesn't get improved, I'd rather use a nice declarative 
dialect, preferably with before and after structures, and have the 
dialect processor generate the parse and REBOL code for me. If that 
dialect is powerful enough to be written in itself then we'll really 
be cooking.
Gabriele:
30-Apr-2006
my rewrite function works quite well for search and replace. it still 
has the limitations of parse, though, but they don't seem a huge 
problem so far.
Ashley:
10-Nov-2008
Almost ... I want to "push" my Address Book (on my iMac) to all the 
IP Phones in our office. I know the address of each IP Phone (10.1.1.x), 
and I can extract the data from Address Book easily enough ... what 
I havn't figured out how to do is replace the manual process of bringing 
up the admin page of each phone (in Safari), keying in the numbers 
and clicking the "Submit" button. Tom's suggestion may be on the 
right track, although I've got no idea what query-string is supposed 
to look like. May be time to dig the old HTML4 manual out! ;)
Maxim:
23-Jun-2009
note that in the above, you can replace types within so it could 
be words instead of tags.
Maxim:
24-Jun-2009
>> probe load replace {#[object! [a: #[object! [b: #[object! [c: 
"%VALUE%"]]]]]]} "%VALUE%" "tadam!"
make object! [
    a: make object! [
        b: make object! [
            c: "tadam!"
        ]
    ]
]
Group: Hardware ... Computer Hardware Issues [web-public]
Ashley:
3-Aug-2007
The more I can virtualize the 'still Windows only apps'

 ... you can even replace Windows itself these days without resorting 
 to Wine. Check out ReactOS ( http://www.reactos.org/), quite a few 
 forum posts indicating that folks are running it on Mac under Parallels 
 ... there was even mention of REBOL/View running on it.
Group: PgSQL ... PostgreSQL and REBOL [web-public]
Oldes:
24-Jul-2005
in function to-octal replace "\\" with "\"
Group: Rebol School ... Rebol School [web-public]
Pekr:
4-Apr-2006
that is the set of proto functions - those string manipulation functions 
- you do use them everywhere ... even in graphics ... you have face, 
which has pane (container), and you insert, append, find, replace 
another gui elements, and then you call 'show ...
Tomc:
7-Jul-2007
Yes Patrick you have it right. The rules I gave would fail 
since you have multiple names/members

I would try to get away from the line by line mentality 
and try to break it into your conceptual record groupings
file, pages, sections, and details...

One trick I use is to replace a string delimiter for a record 
with a single char so parse returns a block of that record type. 

this is good because then when you work on each item in the block 
in turn
you know any fields you find do belong to this record and that 

you have not accidently skipped to a similar field in a later record.

something like this 


pages: read %file
replace/all/case pages "PAGE" "^L"
pages: parse/all pages "^L"

foreach page pages[
	p: first page
	page: find page newline
	replace/all/case page "NAME" "^L"
	sections: parse page "^L"
	foreach sec section [
		s: first section
		sec: find sec newline
		parse sec [
			any [thru "Member" copy detail to newline 
				newline (print [p tab s tab detail])
			]
		]
	]
]
Group: rebcode ... Rebcode discussion [web-public]
BrianH:
14-Oct-2005
Why not do both? Change

    'label word! (here/1: bind here/1 words insert insert tail labels 
    here/2 index? here)
to
    'label word! (
        here/1: bind here/1 words
        set here/2 index? here
        insert insert tail labels here/2 index? here
    )


No, since it wouldn't be set at runtime, it wouldn't be recursion-safe. 
The only safe way to do that would be to replace every reference 
to a label other than the label directive and the literal branches 
with  a constant value of its absolute offset, the one in the labels 
block. Doable, but awkward.
Pekr:
15-Oct-2005
yes, that might be the interface I asked about last time Carl was 
here. He told me he planned to provide API to rebol internals, but 
he told something like it could become complex (even security was 
mentioned iirc) and that rebcode replace it, so ....
BrianH:
22-Oct-2005
There have been suggestions for additional parse operations: remove, 
replace and change. I even suggested an if clause that would allow 
the return value paren to direct the parsing flow. Between these, 
that would take care of the vast majority of the operations performed 
in parens, and thus would speed up parse a lot in practice. Even 
more than rebcode would.
Volker:
22-Oct-2005
I prefer better handling for output. replace and change are quite 
slow (moving the whole tail). instead a fresh string and appending 
there is faster. but tickier to code.
Volker:
25-Oct-2005
sure, but i can change the other way. why start with a bad opcode 
and replace it with a bad, when i can have it the other way around?
Group: Syncing ... Syncing technologies [web-public]
Pekr:
4-Jan-2006
Because there were some licensing issues with SyncML, it was taken 
over by http://www.openmobilealliance.orgor so ... it seems to me 
that OMa DS and DM replace SyncML or so ...
Group: Tech News ... Interesting technology [web-public]
Anton:
9-Jan-2006
Yes, that's what I will do, but I wanted to completely replace the 
phone without having my computer on all the time.
Henrik:
10-Jan-2006
new MacBook Pro to replace the powerbook. 4-5 times faster than the 
current powerbook
yeksoon:
22-Mar-2006
there are talks ....of SQLite in Thunderbird


http://wiki.mozilla.org/Thunderbird:Replace_Normal_Folders_with_Virtual_Folders
DideC:
24-Mar-2006
The windows registry is probably the most "crappy" (native english 
speaker, please replace this word by the word that is in my head 
and I can't find) invention of all the computer history.


If you have a problem and it's not hardware, then it's 99% chance 
it's a registry problem. The 1% rest is for files and DLL problem.

My boring all day experience.
Pekr:
21-Jun-2006
I mean - integrated in similar way, for usage purposes, not to replace 
it ....
Pekr:
20-Dec-2006
1.3 Appropriate Conduct and Prohibited Uses.
... You agree that you 
will not, and you will not permit your users or
other third parties 
to: (a) modify or replace the text, images, or
other content of the 
Google Search Results, including by (i) changing
the order in which 
the Google Search Results appear, (ii) intermixing
Search Results 
from sources other than Google, or (iii) intermixing
other content 
such that it appears to be part of the Google Search
Results; ... 


Amen - so much for a company, which seemed to become new Internet 
"platform" leader .... they seem to be money oriented - that decision 
simply sucks ....
Group: !RebDB ... REBOL Pseudo-Relational Database [web-public]
Ashley:
11-Feb-2006
Thanks guys, I've had a good look at both implementations and I've 
got ideas from both for a future full JOIN implementation; but at 
the moment my master/detail code has come along nicely. I've now 
enhanced the db-select function to accept statements in these additional 
forms:


 select * from master joins [select * from details where &id] on id

 select * from master joins [select * from details where [all [master-id 
 = &id master-date = &date]] on [id date]


which works exactly like a normal join with the following differences:

	a) It can only join one table to another

 b) Detail columns are always joined to the right of master columns

 c) Table.column prefixes are not supported so all columns in the 
 join must be uniquely named


Apart from that you get all the benefits of db-select (can replace 
* with specific column combinations, order and group by on the final 
result set, etc) *and* it's significantly faster than even the raw 
REBOL code example I gave before (as the SQL is parsed once within 
db-select and all loop sub-selects are done in-line).

I've also implemented “lookups” with the following form:

	select * from table replaces id with name
	select * from table replaces [id-1 id-2] with [table-1 table-2]


which performs a highly optimized db-lookup for each replaced value, 
but has the following restrictions:


 a) The lookup expects lookup tables in the form [id label other-column(s)]
	b) Only single-key lookups are supported
	c) A lookup that fails will replace the column value with none!


I'm now in the process of benchmarking these changes against sqlite 
to see where the bottlenecks (if any) are. Feedback on the design 
decisions is welcome.


While I was doing this, I was once again reminded how cumbersome 
it is to construct SQL statements (not just for RebDB, same goes 
for the other SQL protocols), as the heavy use of 'compose, 'rejoin, 
etc adds noise that reduces legibility. The design goal is to provide 
alternatives to:


 sql compose/deep [select * from table where [all [col1 = (val1) col2 
 = (val2)]]]


so for a start the 'sql function should probably accept a string, 
to allow:

	sql join “select * from “ table


type constructs; but this doesn't make the first example easier. 
So how about the 'sql function accept a block containing a string 
statement followed by a number of substitution variables, as in:


 sql reduce [“select * from table where [all [col1 = &1 col2 = &2]]” 
 val1 val2]


which makes things a bit more readable (and shortens the expression 
if longer word names are used multiple times). So the two questions 
here are:

	a) Is this a good idea?

 b) If so, what substitution character (& % $ @ other) will cause 
 the least conflict with REBOL and/or SQL?
Sunanda:
11-Feb-2006
Traditional with embedded SQL, the technique is to use "host variables" 
which start with a colon:

 sql reduce “select * from table where [all [col1 = :var1 col2 = :var2 
 ]]”
And you'd magically replace :var1 with the value of var1.


Which is almost exactly the behaviour you'd expect from :var1 in 
REBOL too.

If you insist that that host variables always have a space before 
and after, that makes the whole substitution process a fairly simple 
parse operation.
Pekr:
12-Feb-2006
Ashley - why 'replace? Do you want to really replace id with looked-up 
value? I can imagine having some usage for 'id, especially in the 
case where 'id is of some meaning. I know it should not be, but e.g. 
some ppl might use, for companies db, companie's registration number, 
which is not anonymous id, and could be further used in the resultset 
...
Group: SQLite ... C library embeddable DB [web-public].
Ashley:
13-Feb-2006
sqlite3-protocol.r has a minor bug whereby locals/cols are not cleared. 
Fix is to add a "clear cols" at the beginning of the ' sqlite-exec 
func. Two other changes I made to this function were:


1) Changing “SQLITE_TEXT [any [attempt [load val: sqlite3/column_text 
stmt j] val]]” so as REBOL values are returned, and

2) Removing the /only clause from "system/words/insert/only tail 
result col" for those that prefer flat data structures (i.e. non-blocked 
records)

Finally, a simple wrapper makes the whole thing more usable:

context [

	db: none

	set 'open-db func [name [file!]] [
		db: open join sqlite://localhost/ name
	]

	set 'close-db does [
		close db
	]

	set 'describe func ['table [word!]] [

  insert db rejoin ["select type, name, sql from sqlite_master where 
  upper(tbl_name) = '" uppercase form table "' order by rootpage"]
		db/locals/sqlresult
	]

	set 'sql function [arg [string! block!]] [statement] [
		case [
			string? arg [insert db arg]
			string? first arg [
				statement: copy first arg
				repeat i -1 + length? arg [
					replace/all statement join ":" i pick arg i + 1
				]
				insert db statement
			]
		]
		db/locals/sqlresult
	]
]

which lets you do stuff like:

>> open-db %test.db
>> sql "create table t1 (col1 INTEGER, col2 TEXT)"
== []
>> describe t1
== [table t1 "CREATE TABLE t1 (col1 INTEGER, col2 TEXT)"]
>> sql reduce ["insert into t1 values (1,':1')" now/date]
== []
>> sql "select * from t1"
== [1 13-Feb-2006]
>> close-db
Ashley:
15-Feb-2006
Yep, wish I had read your message earler. ;)


The 'open func sets port/target to a string of the file name and 
port/path to a string of the path (empty if none). So you just need 
to replace the sqlite-open in the 'open func with:
 
	port/locals/dbid: sqlite-open to-file join port/path port/target

as Anton stated above.
Pekr:
21-Mar-2006
but it is easy to convert to - replace time-value "T" " " " :-)
Ashley:
25-Mar-2006
Replace the column-text block in the SQL function with:

	[(
		either direct [
			[*column-text (sid) idx]
		][
			[
				s: v: *column-text (sid) idx
				while [s: find s {""}] [change/part s "" 2]
				load v
			]
		]
	)]

I've added this to the next build.
Pekr:
1-Aug-2006
I did following modifications to driver:

log-path: to-file copy ""

then replace/all "%sqlite.log" "join log-path %sqlite.log"


then in my cgi script I am able to do sqlite/log-path: %db/ to change 
location ...... maybe it would be usefull to even set db path and 
don't bother with paths, not sure ....
Pekr:
23-Nov-2007
it has insert or replace = replace, but that deletes original record 
and replaces it with new, probably changing row id, so no facility 
like insert .... on duplicate key update .....
BrianH:
23-Nov-2007
MySQL has a non-standard command for inserting if not there for update: 
REPLACE. SQLite has more detailed conflict resolution, but includes 
REPLACE as a MySQL-compatible shortcut for INSERT OR REPLACE (the 
OR REPLACE is itself a shortcut for ON CONFLICT REPLACE). I agree 
that UPDATE should have the option of acting like INSERT OR REPLACE.
Pekr:
23-Nov-2007
our subsidiary company changed IDs of some products during the inventory 
in our system ;-) I need to create table called e.g. transform-id(oldid, 
newid) .... and now I would like to somehow do:


foreach row maintable [if found? in transform table maintable/id, 
then replace maintable/id with newid) :-)
Pekr:
27-Nov-2007
uh, it is update or replace which messes my data with nonsense :-(


update or replace produkty set kod = (select novy_kod from prevodnik 
where prevodnik.kod=produkty.kod)  where exists (select kod from 
prevodnik where prevodnik.kod=produkty.kod)


It is supposed to simply to lookup the "prevodnik" (translator) table, 
if there is new code (novy_kod). both tables seem to be OK, but after 
that statement kod in produkty (products) gets messed up ....
Pekr:
27-Nov-2007
produkty.kod is unique ... if I remove "or replace" part, data seem 
to be OK, but it just no more does what I need it to do ....
Pekr:
27-Nov-2007
I found the culprit but I doubt it is enough to track possible bug. 
Issuing following statement will make subsequent update corrupting 
data:


sql trim/lines "insert into prevodnik select kod, nazev, puvodni_kod, 
puvodni_kod, typ from produkty where substr(kod,1,1)='9' and kod 
like '%BZ'"


update or replace produkty set kod = (select novy_kod from prevodnik 
where prevodnik.kod=produkty.kod) where exists (select kod from prevodnik 
where prevodnik.kod=produkty.kod)
Graham:
22-Dec-2008
I've never tested whether the sql dialect can replace ? inside single 
quotes.
Group: Plugin-2 ... Browser Plugins [web-public]
Cyphre:
10-May-2006
Josh: so you basically need to replace WndProc handler with a plugin 
specific one right?
Oldes:
16-May-2006
Be carefull with restricting Rebol. I like Rebol, because I can simply 
do things, which I cannot do in other apps. I cannot believe, that 
Maxim wants to remove send even from Rebol and replace it with some 
application. Why? Do I need xxMB large aplication just to send message? 
What will be better in Rebol than in Flash, if you remove the best 
parts of Rebol?
Will:
9-Jun-2006
Steve sent a black MacBook to Carl asking him to return it in a month 
with a copy of Rapple, a customized dialect on top of rebol/base 
 that will  replace  AppleScript in 10.6, cause they need a more 
powerful and user friendly glue scriptig language, now that they 
have coreData,coreGraphics,ecc..

..and webkit people are thinking that rebol would better be integreted 
like javascript is, in the browser to rescue the world from all those 
web2.0 heavy cpu/memory consuming inbrowser javascript applications...
Graham:
15-Jun-2006
Yes, certificate support are also needed if we are going to replace 
those java banking apps, and medical applications
Gabriele:
5-Jul-2006
Josh: I guess this could be plugin-only and either replace read-thru 
etc. with a native or provide new port schemes (probably the former 
is much easier). if for some reason it's not possible to make the 
native read-thru compatible with the old mezzanine one then there 
would need to be a new name I guess, but I'm not sure Carl would 
like that (no more cross-platform, although the plugin is already 
single platform rigth now so maybe this is not a big problem for 
r2 and can be solved in r3)
Group: !Liquid ... any questions about liquid dataflow core. [web-public]
Maxim:
2-Mar-2009
all is built using direct faces... no VID no GLayout... just make 
face []   so you can understand exactly what happens, and realize 
how easy it is to replace VID, even in R2.
Group: Games ... talk about using REBOL for games [web-public]
ICarii:
30-Jun-2007
RebTower 0.0.4 released.  This version is playable :)
Quick notes:

left click a card to select it (it will enlarge in size) then either 
left click it again to replace it or right (Alt) click it to play 
it.

only cards that are alpha/0 (ie solid)  can be played unless you 
are discarding.
if all your cards are transparent you will have to discard.

the object of the game is to destroy your oponnents tower while keeping 
yours alive.


Yes, I know the debug info is still displaying - the final image 
cards are not ready yet :)
Group: DevCon2008 (post-chatter) ... DevCon2008 [web-public]
BrianH:
17-Dec-2008
The presenter chat interface is too tall to fit on a 1024x768 screen, 
let alone the 1024x600 on my netbook. It would help if you got rid 
of
  <tr> 
    <td align="center">&nbsp;</td> 
  </tr> 

that is above the row where the flash is embedded, or better yet 
replace the whole table with a
  <div style="text-align: center">...</div>

However, even when you reference the the flash itself, it has some 
kind of title at the top that pushes the interface down so far that 
you can't see the text entry field on a 1024x768 screen. This is 
a bug in the flash.
Group: reblets ... working reblets (50-100 lines or less) [web-public]
Maxim:
19-Mar-2009
bug creep: parens disapeared for some strange reason...  replace 
in the above:


btn 200 left (label) [ explore-dir to-local-file item get in (to-word 
setw) 'data ]

with


btn 200 left (label) [ explore-dir (to-local-file item) get in (to-word 
setw) 'data ]
1 / 852[1] 23456789