Forums

This topic is locked

Ýnsert record without a form

Posted 25 Apr 2001 00:28:52
1
has voted
25 Apr 2001 00:28:52 Some One posted:
How can i add a new record manually to UD code... ?

sdi ::: pixels to blood

Replies

Replied 26 Apr 2001 13:19:51
26 Apr 2001 13:19:51 Waldo Smeets replied:
Try using the Command object that's on the data bindings palette (below the Recordset). Select type=insert and
hand-code your SQL in the window, like

INSERT INTO tableName (column1, column2, etc) VALUES ("value1", "value2", etc)


Waldo Smeets - www.UDzone.com Webmaster
------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
------------------------------------------
Replied 26 Apr 2001 14:08:55
26 Apr 2001 14:08:55 Waldo Smeets replied:
This is an other option:

<%
Recordset1.Addnew
Recordset1.Fields.Item("Count".Value = "YOUR TEXT HERE"
Recordset1.Update
%>

Waldo Smeets - www.UDzone.com Webmaster
------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
------------------------------------------
Replied 26 Apr 2001 23:20:06
26 Apr 2001 23:20:06 Some One replied:
Really thanx for these... <font face='Verdana'></font id='Verdana'>

sdi ::: pixels to blood

Reply to this topic