UD40 Feedbacks

Home

From Paul
Posted 12/14/2006 9:56:40 AM
Comments I've been struggling with DW templates locking the body onload. Tip here was great. Saved me a lot of hassle. Thanks a lot.

From pascal
Posted 6/23/2006 11:13:32 AM
Comments Hi,
I am trying to follow your tutorials to highlight keyword. I did everything but got error msg "vbscript runtime (0x800A0005) invalid procedure call or argument : 'Right'"
Any help please.

Thanks

From MeTin
Posted 6/10/2006 2:27:19 PM
Comments Hi again i just wanted to say they i have found the right direction after couple hours trying thanks for ur help anyway also thank you very much for shareing your knowlege with us and helping us to learn how to make basic things like your tutorials for web sites ..:D

Kind Regards
MeTin

From MeTin
Posted 6/10/2006 11:18:59 AM
Comments Hi there
First of all for the newbee like me u have very nice tutorials also very clear once so anyone can clearly understand but iam going to ask u for a favour if possible ..ive just tried ur highlight search tutorial and it all works but any chance to help me some more and make a link on the search as its on your search page where from the result page u can click on the result and go to detail pages any chance to direct me to find my way to be honest ive tried to make different links but they dont work or i can get the right id from the table so can u please help me if u got some spare time ..
Kind Regards Metin

From Dick Medema
Posted 4/14/2006 7:15:06 PM
Comments I have a question concerning Tutorial 7 I am for quite some time busy these wind up tutorial but unfortunately do not get done I it. I want you ask if it is possible the code of these tutorial and particularly the command update`s mail me.

With a pleasant groet Dick Medema from the Netherlands

From yts
Posted 11/27/2005 3:01:19 AM
Comments Your website is a true help for starters its really great, wish you all the best

From nicolas
Posted 11/18/2005 2:43:24 PM
Comments hello i chearching a tuto that no "Batch delete with checkboxes" but "Batch record ( or insert ) with checkboxes " coul you help me please !!!

From reza
Posted 9/1/2005 1:10:41 PM
Comments hi
cane you tell me how to making search of database in dreamweaver.

From reza
Posted 9/1/2005 1:08:50 PM
Comments hi
i should thanks for your hellpfull site .you hellp me alot.

From sean
Posted 6/24/2005 12:46:37 PM
Comments Hi :
I tried the batch update script sep by step , word by word !!
but for some resaon it does not work .
in page 2 is there anything beside the two command that I have to insert in that page .
also in page is form , when you click on submit ( update) button, does this supose to go to page two .
on the Form property what method
POST or GET
we must use ( multi/form-data or live it blank ,

the sample code that you have is different with what Dreamweaver MX create . is there anything I should do beside what is in your Code .
Thanks

Sean

From Marcello
Posted 4/30/2005 10:00:27 AM
Comments Your tutorials are very useful. I would like ask you a question: it's possible insert multiple records with checkboxes? Have you tutorial to send to me? Thank you
Marcello

From Sean Porter
Posted 4/27/2005 1:49:55 PM
Comments Hello,

Your tutorials are great & they've been a great learning tool for me but Im havin trouble with your Tutorial 3 - Highlight searched word.
Im getting the error message Invalid procedure call or argument: 'Right', it must be realted to
str = UCase(str) & Right(word, len(word)-1)

Have u had this problem?

Thanks for the site & thanks in advance for your reply if possible

Sean Porter

From Nicole
Posted 3/23/2005 6:38:15 AM
Comments Hi I cant seem to get Tutorial 6 - Batch delete with checkboxes to work, could you help me please.

I have the following error
-----
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'RecID IN ()'.
/newtest/delete.asp, line 30

------

I can send you the page if you like.

Any help you could give me on this would be great.


From James Asante
Posted 3/19/2005 10:22:09 PM
Comments Hi,
Do you know of a similar site like yours for MX2004 asp.net C# tutorials? Thanks.

From kais
Posted 2/28/2005 7:28:01 PM
Comments hello, gud clear site, do youu have tutorials od developing an e-commerce site

From Jason
Posted 6/23/2004 5:44:36 PM
Comments Hello,
Could i get you to please remove the post from Toni - Posted
3/5/2004 10:58:15 AM

It contains code for a client's site - and Toni was a developer who didn't work out that we had subcontracted to do the site for us.

Thanks,
Jason

From Gary Nutter
Posted 5/20/2004 11:23:15 AM
Comments Can you send the code for Tutorial 7...it appears the picture cut off the code on the bottom of the tutorial.
Thank you!

From Jere Michals
Posted 4/20/2004 11:38:51 AM
Comments Hi Swee Hoe, You helped me a long time ago and I don't suppose you remember me. All of my friends love your website. My friends and I came up with a problem and we wondered if we could ask you. It has stumped us all. :) Talk to you later. Jere

From Rick
Posted 4/16/2004 3:58:38 PM
Comments Greetings -
I'm trying to follow your tut on repeating form check boxes / inserting mulitple records via a command. I keep receivng the same error message (Microsoft JET Database Engine error '80040e14'
Number of query values and destination fields are not the same.") Was wondering if you had any suggestions? I'd be more than happy to send you the code if you're willing?

Thanks,

Rick

From Sunita Kissoon
Posted 4/14/2004 3:21:29 PM
Comments Hello, I have the following question :
I need to insert multiple records from a single form into a single table. How can I do this in Dreamweaver.

Regards Sunita Kissoon

From Alen Zilic
Posted 3/11/2004 3:44:37 PM
Comments Hello Ong Swee!
1st- many thanx for the site and tutorials I refer to it almost any time I "try to do ASP" :)
I am a bit stuck on tutorial 2 (fitler RS2 by results of RS1)
Could you elaborate to how do we diplay things from RS1 and RS2 in one repated region that is based on RS1.
All I am getting is a blank page and this is what HTML body holds:
<%
While ((Repeat1__numRows <> 0) AND (NOT rsLayouts.EOF))
%>
<td height="183" align="center">
<%=(rsLayouts.Fields.Item("Layout_Name").Value)%><br>
<%=(rsStyles.Fields.Item("Style_Name").Value)%><br>
</td>
<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
rsLayouts.MoveNext()
Wend
%>
the structure of top VBSCRIPT is the same as yours excpet I used RS1.Fields.Item("field").Value for "myVAR" as filter...
If you could take some time to help I would really apprechiate the insight.

From Toni Chee
Posted 3/8/2004 9:11:59 AM
Comments Hi there. I working on the batch updates code and it doesn't like the ID IN (varselect) code. I am getting this error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[MySQL][ODBC 3.51 Driver][mysqld-4.0.16-standard-log]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1

/manager_asp/officersupdate.asp, line 15

Is there a different way to write in that var Select variable so it will take it?

Thanks,
Toni

From Bobeck Lastimosa
Posted 2/4/2004 3:05:45 AM
Comments Can you send me a better copy of Tutorial 8? A portion of the tutorial(left) is missing. Thanks

From walid
Posted 10/9/2003 8:55:16 AM
Comments hi
can i have the full code of update multiple records with checkbox tutorial??
cus i can't using the code in the page ? there are error message say that needed END IF ?
can you help me ?
thanx advance

From louie
Posted 6/17/2003 10:40:25 AM
Comments I am trying to use the tutorial on the search page but I am getting the following error:

Error Type:
Microsoft VBScript runtime (0x800A0005)
Invalid procedure call or argument: 'Right'

This is the code I copied:
<%@LANGUAGE="VBSCRIPT"%><%
Function ReplaceWords(str,word)
strTemp = str
'replace the lower case word
strTemp = replace(strTemp,LCase(word),("<b>" & LCase(word) & "</b>"))
'replace the upper case word
strTemp = replace (strTemp, UCase(word), ("<b>" & UCase(word) & "</b>"))
'replace the word with the first letter in Caps
str = Left(word, 1)
str = UCase(str) & Right(word,len(word)-1)
strTemp = replace(strTemp, str, ("<b>" & str & "</b>"))
ReplaceWords = strTemp
End Function
%>

From marcello ruta
Posted 6/12/2003 3:44:34 AM
Comments I must create page with multiple update of repeated region and I have problem with the code. Could you send me one example of your tutorial(page with entire code)? Thank you very much. Marcello

From marcello ruta
Posted 6/12/2003 3:11:36 AM
Comments I find your tutorial about update of repeat region very useful. But the code it's better have in text mode. Thank you.

From mike cooper
Posted 6/9/2003 1:17:06 PM
Comments Great site. You've answered many of my obscure questions right off the bat. Thanks and keep up the good work. Now I have to get to work.

From Alice
Posted 5/16/2003 12:15:18 PM
Comments Great tutorial on nested records! I was able to accomplish this in less than 5 minutes following your directions. Doesn't get any better than that.

From nema veze
Posted 4/30/2003 6:06:41 PM
Comments Great work Swee!
Right to the point...no tales...no private messages included in tutorials...just UD!
Thanx!
p.s. I saw your site 1-2 yrs ago and after having to do some more resarch on ASP I came back to it! :)
only this time arround I am leaving you a little note :)
Keep it up!

From nema veze
Posted 4/30/2003 6:06:36 PM
Comments Great work Swee!
Right to the point...no tales...no private messages included in tutorials...just UD!
Thanx!
p.s. I saw your site 1-2 yrs ago and after having to do some more resarch on ASP I came back to it! :)
only this time arround I am leaving you a little note :)
Keep it up!

From james
Posted 4/30/2003 1:19:58 PM
Comments hi there, great site thanks for the useful tutorials. Just wonder if you can help me at all im using the "Filtering records based on Month or Day from a Date column" and its all working well but id really like to search by year and month instead of month and day could you help ?

many thanks

James

From Simon Bossie
Posted 4/8/2003 7:07:31 PM
Comments Hi

Thank you for your website i find it very helpful. I do have one question for you I am using your batch delete with checkboxes function for a site I am building. The problem is that the field in the db that I pass to the delete page is not the id field, it is unique but it is not the id or autonumber field in access.

When I tick just one box it works and deletes the record if I try to delete multiple it does not work, any suggestions would be great

Thanks

Simon

From denard Jacox
Posted 3/27/2003 8:33:31 PM
Comments I can't access Owen Palmer site? any help

From Phil
Posted 3/25/2003 6:38:20 AM
Comments Hi,

I wonder if you are able to help me.

I just can't seem to find a solution to this redirection problem. I have tried many places but have been unsuccessfull. Perhaps you would know and can help.

I want to redirect the following to the correct browser version:

http://www.myyysite.com/test.asp?id=123


I have a browser detection page in the middle (using the Magicbeat server
behaviour 'detect browser and redirect') to Internet Explorer version
here:

http://www.myyysite.com/test_ie.asp?id=123

note the difference: _ie

I'd be obliged if someone could let me know how it is done, it's driving me nuts!

I'm using Dreamweaver MX.

Thanks.

Here's the redirection script I'm using:

<%
agent = Lcase(Request.ServerVariables("HTTP_USER_AGENT"))
nslash = InStr(1,agent,"/",1)
name = Left(agent, nslash -1)
vers = Right(agent, Len(agent) - nslash)
if InStr(1,name,"mozilla",1) > 0 Then
if InStr(1,agent,"spoofer",1) = 0 AND InStr(1,agent,"compatible") = 0 Then
name = "Netscape"
Else
If InStr(1,agent,"msie",1) > 0 Then
name = "Microsoft"
End If
End If
End If
if InStr(1,name,"Microsoft",1) > 0 AND CSng(Left(vers,3)) >= 4.0 Then
Response.Redirect("index_ie.asp")
Else
If InStr(1,name,"Netscape",1) > 0 AND CSng(Left(vers,3)) >= 4.0 Then
Response.Redirect("index_ns.asp")
Else
If InStr(1,name,"Netscape",1) > 0 AND CSng(Left(vers,3)) >= 3.0 Then
Response.Redirect("index_ns.asp")
Else
Response.Redirect("index_gen.asp")
End If
End If
End If
'MagicBeat Server Behavior - 1023 - by Jag S. Sidhu - www.magicbeat.com
%>

From Sam
Posted 3/3/2003 4:27:29 AM
Comments I'am following your tutorial on Batch update using checkbox and have successfully implemented it with a repeat region that show all records.

But I have a problem on how to get it to work if I have a repeat region showing part of the records with navigation link.

From raj
Posted 2/24/2003 9:59:17 AM
Comments In reference to the following tutorial:

http://www.chronoworks.com/ud40/tutorial3/index.asp

A user fills out a form (by entering keywords) on our website and a list
of matching records are returned. The user then clicks on one of the
records and the record id and the keyword the user entered is passed to a
detailed view of the record.

What I would like to do is highlight all instances of the keyword the user
has searched on. How would I do this?

I have tried using the sample code you provided in the tutorial but I encounter problems when the keyword is contained within an html link or image tag. The html (url and/or image) becomes fragmented.

Your help and advice would be appreciated.

Thank You

From Chris Bizzell
Posted 2/19/2003 9:40:37 AM
Comments Can you send me the source files for the Update repeated region tutorial. I like the way you set this up but am confused by a few things. Thanks

From Eli
Posted 2/17/2003 4:32:35 PM
Comments I enjoy your tutorial, great job lots to learn from you...keep it up

Thanks Greatly
EJ

From Shaq
Posted 2/17/2003 9:12:03 AM
Comments Hi,
thanx for the tutorials, they are real help, thanx again. I had a go trying to work the multi-record deletion, I found that the command executes once only. if I select for the second time some other records it doesnot delete them. Can you help me please?

thanx
Shaq

From martin meigh
Posted 2/13/2003 3:03:19 PM
Comments I have implemented a Search Page that returns results in a repeated region
on the Results Page. On my Search Page I have a List Box that allows
multiple selections. A single selection works fine, but if I Post more than
one selection to the Results Page - there is no error and the page is blank
Can you help please

From Simon Bossie
Posted 2/12/2003 10:54:36 PM
Comments Hi

Just a question about batch delete I have two access db tables first page outputs the records of one and passes a url parameter of Username

second page supposed to match username to username in second db table and then delete

Problem is that if I select only one record it works if I select more than one it does not work

Any clues on how to fix this would be good

Also thankyou for helping people like me by providing tutorials on the web for us to look at

Kind Regards

Simon Bossie

From Bryan Sorensen
Posted 1/28/2003 8:52:59 AM
Comments Hi,

I'm trying to do the multiple checkbox update tutorial and I get a "too few parameters' error, which is associated with this code:

comUpdate.CommandText = "UPDATE Tutorials SET Status = -1 WHERE ID IN (" + Replace(comUpdate__varSelect, "'", "''") + ")"

If I set a hard value to the ID it works. Your tutorial is an image and the actual code is cut off, so I did some experimenting to get it this far. Would it be possible to get a zip file of your working code (without the db) at the e-mail address I've given.

Thanks,
Bryan

From WOOF
Posted 1/22/2003 8:12:30 PM
Comments I have searched everywhere trying to find a tutorial on updating multiple records with checkboxes from one form and thought you had saved me. Alas, the bottom graphic on your page which displays the code cuts off the code on the right hand side. Is there any way you could upodate this graphic or at least email me the code? It would be greatly appreciated, I have spent days trying to work this out. You have a great site and your hard work apparent!!!
Thanks!
http://www.chronoworks.com/ud40/tutorial7/index.asp

From giani
Posted 1/21/2003 9:32:18 AM
Comments i tried your tutorial for updating repeating region and it just does not work. is there anyway you can help me with the code

From Travis Baseflug
Posted 1/17/2003 7:46:39 AM
Comments Good morning -

I know that you are probally very busy, so understand if you cannot answer, but am trying the update tut and I am trying to utilize an update command and everything is workign great with the exception of when I try to insert the following in th where clause:

WHERE people_id = Session("people_id_session")

If I hard-code in the actual id value such as:

WHERE people_id = "1234"

Then it works, but with the Session plugged in, I get the following error msg:

Microsoft VBScript compilation (0x800A0401)
Expected end of statement

Again, do not feel as if you have to respond, but any help would be greatly appreciated!!!

From Joey
Posted 1/16/2003 11:21:17 AM
Comments Hi Swee Hoe,

I am trying to filter a column with the "IN" operator. I went through your tutorials for batch update/delete. I want to do something similar but with out a command. what I am trying to do is filter checkboxes. It works fine if one check box is selected but if multiple check boxes are selected I get no results. Here is the code...

SELECT *
FROM tblSubscribers
WHERE AllMailings IN ('varChoices') AND HTMLMailings = 'Yes' AND DateUpdated <(now()-2);

Here is my Variable

varChoices xyz Request("AllMailings")
Any ideas on what I am missing?
Any help greatly appreciated.

Joey Durham
www.ultraweaver.com

From Kim Nisbet
Posted 12/19/2002 11:20:33 PM
Comments Hi am am using DWMX and trying to adopt the UD40 tuts. I am doing Number 4 Simple mail listing.

I am just a bit confused.

I gather there is 3 pages required.

One with a text field for the body and the Submit button, with the 'get' to the page with the repeat code in it and then a third page, the confirmation page is viewed after sending page.

Is that correct?

From Gary Stockton
Posted 12/18/2002 7:29:37 PM
Comments Would you know where I could locate a tutorial for batch insert via checkboxes?

Thank you in advance for your reply.

From Edward Cheong
Posted 12/18/2002 3:39:53 AM
Comments Hi Ong,
Its me again. Can you please send me the actual working files so that I can have look and compare whether what kinda mistake I have made? I keep on trying trying and trying but yet the result is still the same. Same error.

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
/ctrlpanel/artisan_script2.asp, line 18

From Edward Cheong
Posted 12/17/2002 11:06:47 PM
Comments Hi,
I've try out your tutorial #10 but it was not working as it should be. I get this ASP error as follow:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
/ctrlpanel/script_update.asp, line 24

Then I change the data type in Access from AutoNumber to Text and everything work fine. But this doesn't seem to be the right way. Please kindly advise. Thanx!

From Travis Baseflug
Posted 12/12/2002 4:20:19 PM
Comments Hello - great site and TUTs - wanted to ask if you could apply the same technique for multiple updates, etc to an insert statement? Essentially, I want to "move / copy" rows from one tabel to another based upon the selection of the checkbox?
Any help would be a lifesaver!

From Mark Ryder
Posted 12/9/2002 10:36:25 AM
Comments Thank you SO much for the nested tutorial - brilliant!!

From Don McKee
Posted 12/4/2002 3:29:36 PM
Comments I am trying to use your update repeated region. I followed the three pages and was able to understand all have done as told but get an error when the page shows on the web here is the error:ADODB.Field error '800a0bcd'

Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

/admin/category/UpdateModelID.asp, line 290
when I look at line 290 I find the following: <input type="hidden" name="MM_recordId" value="<%= rslegacysql.Fields.Item("ProductCode2").Value %>"> I know that you talk about ID number and I have an ID field which is an auto number which is provided when the record is created. The data source is SQL 2000 the ID type is int. the page looks like your demo except for the error and when you press submit nothing happens.

From Shah
Posted 11/28/2002 3:45:59 AM
Comments Hi
the following query throws an error
rs.open "select * from ProRec "_
& " Where Size = 13 ", Mycon

Error Type: (0x80004005) Unspecified error

but It Works fine when i remove the condition part in the query, like..
rs.open "select * from ProRec ",Mycon

Please help me with that.

Shah

From Shah
Posted 11/28/2002 3:38:27 AM
Comments Hi
I dont know what is wrong with this code.
rs.open "select * from ProRec "_
& " Where Size = 13 ", Mycon

it gives the following error

Error Type: (0x80004005) Unspecified error

please help me finding the solution.

Thanks

From chris cullen
Posted 11/27/2002 6:23:54 AM
Comments Ive tried using your advanced script for non case sensitive highlighting search words via database query; Im getting a error as below:
Error Type:
Microsoft VBScript compilation (0x800A03EE)
Expected ')'
/iss_system_audit/search_highlight_advanced.asp, line 12, column 43
strTemp = replace(strTemp,str,("<b>" & str "</b>"))

Ive tried removing space etc but erros still appearing. Any thoughts
Chris

From Adrian Edelmann
Posted 11/20/2002 3:56:33 PM
Comments Cool site! It helped me very much!
Thanks! Do you make more tutorials, like formmail or so...?

From Alex Rigo
Posted 11/19/2002 5:42:03 AM
Comments I have tried tutorial 7 without success. Your code at the the end of the tutorial is a gif file (pic08.gif). I think i am going wrong because i dont know what comUpdate varSelect equals in the <% if (Request.Form("Checkbox") <> "") then comUpdate_varSelect = line. Because it is an image what comes after the = has been cut off. Can you please let me know what this should equal, or send me the complete code.

Thankyou

I hope this all makes sense

From James
Posted 11/15/2002 2:56:10 AM
Comments hi, im tryin to pass a query string threw my sql statement like this sql="select * FROM tblResponse WHERE MessageID='"& request("MessID") &"';"
it keeps saying data type missmatch how can i get it working???

From Amanda Farr
Posted 11/15/2002 1:30:58 AM
Comments THANK YOU :) I had worked for about 3 hours on various update multiple records tutorials.. and yours was the last one I was able to find and that only one that worked :)

From Tim Wilson
Posted 11/14/2002 10:49:57 PM
Comments Thanks for the great tutorial site!

I have been looking for a batch-insert tutorial and haven’t found one. Essentially I am wanting to make a simplified shopping cart that uses check boxes instead of buttons to add items to a cart. In other words, a list of 100-500 items are presented all on one page and the client and just check the boxes of the items they want. Then hit one button add these items to the cart. This is not an e-commerce site but an informational site where visitors check the items that they want more information on.

Anyway, if you know of any such tutorial or could point me in the right direction, I would really appreciate it.

Thanks again!!!

From Sam
Posted 11/14/2002 7:24:18 PM
Comments I would like to do an order entry routine for a customer with many line items in a single form.

To have the line item field automatically increase by one line once an item is entered. (like a browse insert mode)

The customer's information will be taken from the customer's table and the line items will be from the product's table and thus the order informations will be stored in the order table.

How can I accomplice this. Hope you could have a tutorial on this as I can't find it anywhere in the web. Many only show on single record insertion routine.

Thanks

From Jon
Posted 11/13/2002 4:11:45 PM
Comments Hi,

Found your site from google as I needed a simple method of deleting multiple records using checkboxes. I can't believe how simple it actually was.... A+++ tutorial.

I wondered though, perhaps you've been asked before. How would you add a link to check all the checkboxes in the repeat region? (As commonly seen)

Thanks,

Jon

From Kenny
Posted 11/11/2002 6:22:00 AM
Comments HI,
Just found your site using Jeeves, I have a problem, if you can help I would be greatful. I want to make a link on my page from a value in a hidden field, for the life of me I cannot get it to work. i have my hidden field but when I say go to detail page I dont get to the the page i want using the hidden field. where am i going wwrong.

Kenny

From Gary Cane
Posted 11/6/2002 7:15:36 AM
Comments First thank you for your tutorial on updating on same page. It was straight forward.
I have worked the code into one of my pages but I am getting an error on the line of responce.redirect, saying Object required: 'Responce'
If you have the time could you please look at my code and see if you can tell what is wrong with it.

Thank you for your time
Gary

<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="Connections/Invoiveppab.asp" -->
<%
If Request.Form("Submit").count > 0 Then
Dim iCount, iLoop, varText, varID
iCount = Request.Form("tCnt") 'iCount is number of records to be updated

'Create the ADODB connection
Dim Command1
set Command1 = Server.CreateObject("ADODB.Connection")
Command1.ConnectionString = MM_Invoiveppab_STRING
Command1.Open

For iLoop = 1 to iCount
if(Request(iLooop & ".password") <> "") then command1__varText = Request(iLoop & ".password")
if(Request(iLooop & ".ID") <> "") then command1__varText = Request(iLoop & ".ID")




Command1.CommandText = "Update adminusers SET password = '" + Replace(Command1__varText, "'", "'") + "' WHERE ID = " + Replace(Command1__varID, "'", "'") + ""
Command1.CommandType = 1
Command1.CommandTimeout = 0
Command1.Prepared = true
Command1.Execute()
Next
Set Command1 = Nothing
Responce.redirect ("testnewupdate.asp")
End IF
%>

From Sander
Posted 10/28/2002 10:01:22 AM
Comments Hi Swee,

First I want to tell you that your tutorials are great!

I'm busy making a search/results page. I want to use one textbox and four radio buttons. With the radio buttons the visitor can select a specific column of the table to search for the given keyword. When I make these pages with a list/menu box there is no problem. Maybe you could give me some advise how to do the same with radio buttons instead of a list/menu box.

Thanks in advance!

Best regards,
Sander

From Jay Luther
Posted 10/10/2002 11:55:33 AM
Comments Hi,
Great job on the tutorials. They are very clear and helpful. Do you plan to do more? Also do you accept Tutorial suggestions?

Thanks again,
Jay

From Alfredo Cordova
Posted 10/1/2002 9:49:40 AM
Comments Hello, my question focuses towards the tutorial 7, that changes the state from 0 to -1 or vice versa the change is of numbers, but if desire to do a change like for example of TAKEN CARE OF GIVEN, change of text and to this I add in another field the date with instruction NOW(). THANKS

From Hardip
Posted 9/29/2002 10:03:26 AM
Comments Hi There

I have used many of the tutorials on your website to bring me upto speed with Dreamweaver MX and would like to thank you for taking the time & trouble to prepare such excellent tutorials.

I have a question regarding the "Multiple Update" tutorial. How can I extend this tutorial so that more than one field can be update. At present only the checkbox fields are updated. But what if three or four texts fields which also need updating.

Would you have the time to suggest how this can be developed above your correct example?

I feel a little odd asking for something, especially given that you have done so much.

I trust you are well and in good spirits and I hope to hear from you soon.

Best regards
H

From Tracey Johnson
Posted 9/23/2002 10:10:05 AM
Comments I found your tutorial regarding body uploads very helpful. It worked! My problem now is I have inserted another form on the same page and I would like the cursor to appear. How do I do this?

Thank you in advance,
Tracey Johnson

From Ravi Ram
Posted 9/22/2002 1:30:43 PM
Comments I want to submit a form "onload" within a Template. Looked at your tutorial and still cant get the code to work.

<script language="javascript1.1">
window.onload = document.countInsert.submit
</script>

Any thoughts?

Ravi

From Reminx
Posted 9/19/2002 4:17:47 AM
Comments Hi,

I am quite intermediate user of Macromedia Ultradev. I have found your tutorial very useful - for Multiple Updates of one table.

Unfortunately I can not run it successfuly and therefor I would like to ask you for your help. I know you are very busy, but I tried everything, but could not go through.

I would really appreciate your help. Here is the code of the "form" page and also the "update page.

Table is called zapasy (meaning Matches in English) and I need to update socer scores for several matches at once.

"Form" page:
<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="Connections/newfc.asp" -->
<%
Dim rs_update__MMColParam
rs_update__MMColParam = "muzib"
if (Request.QueryString("select") <> "") then rs_update__MMColParam = Request.QueryString("select")
%>
<%
Dim rs_update__MMColParam2
rs_update__MMColParam2 = "1"
if (Request.QueryString("select2") <> "") then rs_update__MMColParam2 = Request.QueryString("select2")
%>
<%
set rs_update = Server.CreateObject("ADODB.Recordset")
rs_update.ActiveConnection = MM_newfc_STRING
rs_update.Source = "SELECT * FROM zapasy WHERE kategorie_text = '" + Replace(rs_update__MMColParam, "'", "''") + "' AND kolo = " + Replace(rs_update__MMColParam2, "'", "''") + ""
rs_update.CursorType = 0
rs_update.CursorLocation = 2
rs_update.LockType = 3
rs_update.Open()
rs_update_numRows = 0
%>
<%
Dim Repeat1__numRows
Repeat1__numRows = -1
Dim Repeat1__index
Repeat1__index = 0
rs_update_numRows = rs_update_numRows + Repeat1__numRows
%>
<html>
<head>
<title>Test Multiple</title>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1250">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<form name="form1" method="post" action="update_new2.asp">
<table width="800" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="253">zapas ID</td>
<td width="119">domaci</td>
<td width="150">hoste</td>
<td width="130">skore</td>
<td width="148">skoreh</td>
</tr>
<% Dim iCnt
iCnt = 0
%>
<%
While ((Repeat1__numRows <> 0) AND (NOT rs_update.EOF))
%>
<tr>
<td width="253">.
<%=(rs_update.Fields.Item("zapasID").Value)%>.
<% iCnt = iCnt + 1 %>
<input type="hidden" name="<% = iCnt %>.ID" value="<%=(rs_update.Fields.Item("zapasID").Value)%>">
</td>
<td width="119"><%=(rs_update.Fields.Item("domac_text").Value)%></td>
<td width="150"><%=(rs_update.Fields.Item("hoste_text").Value)%></td>
<td width="130">
<input type="text" name="<% = iCnt %>.domaci" value="<%=(rs_update.Fields.Item("skore_dom").Value)%>">
</td>
<td width="148">
<input type="text" name="<% = iCnt %>.hoste" value="<%=(rs_update.Fields.Item("skore_host").Value)%>">
</td>
</tr>
<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
rs_update.MoveNext()
Wend
%>
<tr>
<td width="253">&nbsp;</td>
<td width="119">
<input type="hidden" name="tCnt" value="<% = iCnt %>">
</td>
<td width="150">&nbsp;</td>
<td width="130">&nbsp;</td>
<td width="148">
<input type="submit" name="Submit" value="Update">
</td>
</tr>
</table>
</form>
</body>
</html>
<%
rs_update.Close()
%>



--------------------------------
"update" page

<%@LANGUAGE="VBSCRIPT"%>
<%
If Request.Form ("Submit").Count > 0 Then
Dim iCount, iLoop, varText, varTexty, varID
iCount = Request ("tCnt")

set Command1 = Server.CreateObject ("ADODB.Command")
Command1.ActiveConnection = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=D:\wwb\fchwa\data\newfc.mdb"

For iLoop = 1 to iCount
if (Request (iLoop & ".domaci") <> "") then Command1__varText = Request (iLoop & ".domaci")
if (Request (iLoop & ".hoste") <> "") then Command1__varTexty = Request (iLoop & ".hoste")
if (Request (iLoop & ".ID") <> "") then Command1__varID = Request (iLoop & ".ID")
If Len (Trim (Request (iLoop & ".domaci") ) ) = 0 Then Command1__varText = "NO ENTRY"
If Len (Trim (Request (iLoop & ".hoste") ) ) = 0 Then Command1__varTexty = "NO ENTRY"

Command1.CommandText = "UPDATE zapasy SET skore_dom = '" + Replace(Command1__varText. "'", "''") + "', skore_host = '" + Replace(Command1__varTexty. "'", "''") + "' WHERE zapasID = " + Replace(Command1__varID. "'", "''") + ""
Command1.CommandType = 1
Command1.CommandTimeout = 0
Command1.Prepared = true
Comand1.Execute ()
Next
set Command1 = Nothing
Response.redirect ("form_test.asp")
End If
%>

<html>
<head>
<title>druha strana</title>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1250">
</head>

<body bgcolor="#FFFFFF" text="#000000">

</body>
</html>



---------------------

Thanks for your involvement!!!!!

Reminx

The page location is: http://www.fchaje.cz/update_new.asp

From Whitney
Posted 9/17/2002 6:18:13 PM
Comments Could you point me in the right direction to have 2 recordsets and 2 navigation bars on the same page. I've looked for 2 weeks now and I can't get past this problem I'm using DWMX and Oracle. Thanks again for any help...

From Anwar Thomas
Posted 9/11/2002 10:20:05 AM
Comments I am in depserate need of a tutorial that shows me the best way to make multiple selections in a list box and send those results to an access database.

Thanks.

From Patty
Posted 8/26/2002 11:47:13 AM
Comments Hi there,
May I ask one question? I would like to learn Dreamweaver and PHP, but my system is windows xp home editor. I am not sure can I combine two software functions? What kind of sytem I should setup up? (Linux? windows 2000 professional? windows 2000 server? NT........?) I also hope to keep windows xp on my notebook. Thanks

From Dave McCandless
Posted 8/20/2002 2:58:29 PM
Comments sorry but much of the text on right hand margins is being lost...

From Rob
Posted 8/12/2002 2:32:14 PM
Comments Hi,
I tried using the "insert records into multiple tables" tutorial, and I always get the same server error "Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
/test/1.asp, line 16"

Do you have a working example yourself that I could take a look at?

Thanks,
Rob

From riHuang
Posted 8/3/2002 3:01:11 AM
Comments I am new to ultradev.
UD40 is cool.
But if put the sample ASP code on web will be best.
For example,I am trying to learn Tutorial 10.
But I don't know how to set the update button action.
Always got error msg said no value.
If having the Demo ASP code will be good
Thanks

From steve
Posted 8/1/2002 5:28:21 PM
Comments Thanks a lot for your tutorials - they really helped me do multiple updates and deletes

From jun
Posted 8/1/2002 1:15:58 PM
Comments Hi Swee,
Your tutorials are great!I like tutorial 3 which I've been looking all over for long time.I'm still newbie in ASP/VB but well familiar with DW/UD. I tried very hard to do the second option but I can't get it right. I wonder if I can download the zipped files so I can see where I made mistake. Thanks a lot!

From Jere
Posted 7/31/2002 12:52:08 PM
Comments Hello UD40,
Absolutely brilliant! I've used the Batch Update tutorial and made it through in one shot. Your step-by-step explainations are perfect. So many tutorials out there teach with the idea that you know every term and process and think they are helping by adding links to words. What I mean is, for example, Batch Update. Other sites would say "Create a batch script and blend it with the update script and you are done." They would link the word 'Batch' so you would have to go somewhere else to learn about batch and the same for 'Update'.
Your tutorials have everything right there, and without "IF" all over the place. You know those 'technobable' goofs who talk like "It is easy to do this if you want that but only if you include this, and that's only if you need this if you already have that".
Even though your collection of tutorials is small it is the best "real world" collection I've seen.
I think Macromedia should sponsor your site.
As far as suggestions go there is really only one thing.
I'm torn between being able to copy and paste the script samples or not. On one hand it would be much faster to copy and paste but there is a real sence of accomplishment from re-typing the code. Even though is pretty much letter for letter, re-typing the code makes you feel like it's your own and that you did it. I've changed my mind, I like the fact you have to re-type the scripts and hope you don't change it. It keeps it more of a tutorial instead of a script warehouse.
I don't suppose you take script questions but if you do I'd like to ask you a simple one. Feel free to contact me and thanks again for having such a great site.

From Gary Nissim
Posted 7/31/2002 5:04:55 AM
Comments Swee Hoe Ong

Like your tutorial 10 on Update repeated region. I am using this to update 2 fields using textbox from a repeat region. I seem to be having trouble with the update statement

Command1.CommandText = "UPDATE cctIdentifier SET Type = " + Replace(Command1__varActCctNo, "'", "''") + " , " + Replace(Command1__varADate, "'", "''") + " WHERE RecordNumber = " + Replace(Command1__varRecordNumber, "'", "''") + " "

I think it is where the 2 values are joined in the statement but am able to get it to run.

Any ideas would be gratefully received

thank you

From andy
Posted 7/19/2002 9:09:58 AM
Comments Excellent site. I'd urge you to continue publishing tutorials. Yourself and the others who post tips, tutorials, and extensions have saved my bacon countless times and taught me anything I know. Although I depend on them less and less the more of them I follow, they are an invaluable source of information.

Keep it up.

From Bobeck Lastimosa
Posted 7/9/2002 11:22:00 PM
Comments In relation to Tutorial No. 3, can you show me how to use it searching through 4 fields getting inputs from only one search textbox?...thanks a lot in advance.
UD40/PWS/MSAccess2000/VBScript/ASP

From Jeremy Conn
Posted 7/6/2002 9:19:05 PM
Comments Bro, your tutorials are awesome and are very helpful. Excited to see what you will come up with for DWMX... Good work. - JC

From aj
Posted 7/2/2002 11:32:22 AM
Comments Hi
can you help with this I am using yourcode below to update records in a
repeat region.
It work fine if I use one form element ie actionele (textfield), but if i
add another text field like below it gives me
this error message:-

Incorrect syntax near 'ACTIONELE'.

code:-


<%
If Request.Form("update").Count > 0 Then
Dim iCount, iLoop, VarTxt, varText, varID
iCount = Request("tCnt") 'iCount is the number of records to be updated

set Command1 = Server.CreateObject("ADODB.Command")
Command1.ActiveConnection = MM_client1_STRING

For iLoop = 1 to iCount
if(Request(iloop & ".ELEMENTORDER") <> "") then Command1__varTxt =
Request(iloop & ".ELEMENTORDER")
if(Request(iloop & ".ACTIONELE") <> "") then Command1__varText =
Request(iloop & ".ACTIONELE")
if(Request(iLoop & ".ID") <> "") then Command1__varID = Request(iLoop &
".ID")
'Mark empty text fields as Missing
If Len (Trim(Request(iLoop & ".ACTIONELE"))) = 0 Then Command1__VarText =""

Command1.CommandText = "UPDATE MAINPACKAGE SET ELEMENTORDER = '" +
Replace(Command1__varTxt, "'", "''") + "' ACTIONELE = '" +
Replace(Command1__varText, "'", "''") + "' WHERE ID = " +
Replace(Command1__varID, "'", "''") +""
Command1.CommandType = 1
Command1.CommandTimeout = 0
Command1.Prepared = true
Command1.Execute()
Next
set Command1 = Nothing
Response.redirect ("edit-elements.asp")
End If
%>


From AJ
Posted 6/25/2002 7:57:02 AM
Comments Hi
Can you help me with this one, I wont to add a checkbox to your update repeated region.
I have given the checkbox the following name CHECKELE and assigned a counter to it like with the text field.
I cannot get it to work can you take a look and till me where i am going wrong please.

<%
If Request.Form("Submit").Count > 0 Then
Dim iCount, iLoop, VarText, varID, varSelect
iCount = Request("tCnt") 'iCount is the number of records to be updated

set Command1 = Server.CreateObject("ADODB.Command")
Command1.ActiveConnection = MM_client1_STRING

For iLoop = 1 to iCount
if(Request(iloop & ".COMMENTS") <> "") then Command1__varText = Request(iloop & ".COMMENTS")
if(Request(iLoop & ".ID") <> "") then Command1__varID = Request(iLoop & ".ID")
if(Request(iLoop & ".CHECKELE") <> "") then Command1__varSelect = Request(iLoop & ".CHECKELE")
'Mark empty text fields as Missing
If Len (Trim(Request(iLoop & ".COMMENTS"))) = 0 Then Command1__VarText ="No Entry"

Command1.CommandText = "UPDATE MAINJOB SET COMMENTS = '" + Replace(Command1__varText, "'", "''")+ "'CHECKELE = '" + Replace(Command1__varSelect, "'", "''") + "' WHERE ID = " + Replace(Command1__varID, "'", "''") +""
Command1.CommandType = 1
Command1.CommandTimeout = 0
Command1.Prepared = true
Command1.Execute()
Next
set Command1 = Nothing
Response.redirect ("selfclose.asp")
End If
%>

From Karen
Posted 6/22/2002 8:34:50 AM
Comments Thank you, thank you, thank you...
Batch Delete was EXACTLY what I was looking for. I had found one other but couldn't get it to work right. Yours, well as I said "Thank You"!

From Anonymous
Posted 6/21/2002 3:34:17 PM
Comments Thank you so much for putting up the batch multiple delete tutorial. I was missing some key points, and your tutorials cover it. Thanks.

From Eleanor
Posted 6/20/2002 6:46:02 AM
Comments Hi
I tried your tutorial on 'Batch update with checkboxes' but I'm afraid it didn't work. Any chance you check you code or post your working code on your site so I can copy and paste it?
Regards
Eleanor

From Marios Pieri
Posted 6/19/2002 9:30:54 AM
Comments regarding tutorial 4 "A Simple Mailing List" Please be so kind to help me because i received the following message

Error Type:
Provider (0x80004005)
Unspecified error
/vat/mailist.asp, line 5


Line 5 is the following code :

rsName.ActiveConnection = MM_vat_STRING



From Daniel
Posted 5/30/2002 6:08:48 AM
Comments If you can help me, let me know. I want to connect in Dreamweaver Ultradev to an Access linked table. I have imported a txt file into Access which has converted fine into a table, however when I create a recordset I can't access the table in any way. DANIEL

From Padam
Posted 5/13/2002 9:46:48 PM
Comments Dear owner of the site.
I am a graphic designer but totally new to webdesign.
Please advise where can I start form basics of UltraDev

From Chris Lo
Posted 5/12/2002 8:12:03 AM
Comments Hi Swee, great tutorials, I was banging my head on the desk until I found the solution here. Thanks!
Chris

From khan
Posted 5/6/2002 7:58:53 PM
Comments Hi,
Pleeeeaaaaassseeee help
I asked the same question on so many forums but alas inteligent people were out of town so here i am with a request to help me resolve my problem.
I want to use the command function here. I red your tutorials they are excellent still i am goof.
I have a page that shows all the users along with there mail adresses. I can send them all mails with a click.
What i wanna do is: to add a check box in the repeat region so that one may choose who should receive a mail and who not.
If the checbox is clicked then this particular user will get a mail otherwise he will be excluded.

The code so far that i use to send all mail is:

<%
set grid = Server.CreateObject("ADODB.Recordset")
grid.ActiveConnection = MM_connDUforum_STRING
grid.Source = "SELECT M_ID, M_FIRST, M_LAST, M_EMAIL FROM MEMBERS"
grid.CursorType = 0
grid.CursorLocation = 2
grid.LockType = 3
grid.Open()
grid_numRows = 0
%>
<%
' connect to the MS Access database in the same directory
strDbPath = Server.MapPath(".") & "\******\******.mdb"
ConnectStr = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & strDbPath & ";PWD=********"

Set rs = Server.CreateObject("adodb.recordset")
rs.Open "MEMBERS", ConnectStr, 2, 3

If Request("Send") <> "" Then
' send email to all users
Set Mail = Server.CreateObject("Persits.MailSender")
Mail.Host = strHost

Mail.From = "****@****.com"
Mail.FromName = "Webmaster"
Mail.Subject = Request("Subject")
Mail.Body = Request("Body")

' read address from DB and put them in the BCC field
While not rs.EOF
Mail.AddBcc rs("M_EMAIL"), rs("M_ID")
rs.MoveNext
Wend

' finally: send message
Mail.Send

Response.Write "e-mail has been succesfully sent!"

End If

%>

so what do i do to use commands and make my dream come true.or else any good tutorial you might recommend me.

From Phuc Ngo
Posted 4/25/2002 1:11:59 PM
Comments Hi Swee,

I have been working at this problem for almost 2 days now and can't get it to work. Could you help me out?

Let say i have two tables... Table1 and Table2

In Table1 I have a field called "classId" (number)

In Table2 I have 3 fields called "classId" (primary key, autonumber), classType (text), and classLevel (text)

What i wanted to do is to combine the 'classType' and 'classLevel' together then taking the 'classId' of those two fields and sent it to the 'classId' field in Table1

What I have done now is...
I have a form, in it I have a drop down menu. i created a recordset like this

SELECT classType + classLevel as [className], classId
FROM class_info
ORDER BY classType ASC, classLevel ASC

then bind the drop down menu with className.

For the List Values of the dropdown box, I've set it to be like this:

Item label -> I selected className
Value -> I select classId
Select Value Equal to -> I select classId

Then I apply the insert record to the form, which, if work properly would take the classId in Table2 and insert it into the classId field in Table1.

From Lorenzo
Posted 4/24/2002 2:59:38 PM
Comments I like the tutorial on the simple mailing list. Thanks for the help.

How do i modify the code to suit my server? You didn't say which elements to change. Could you help with this. I guess it's probably obvious, but I want to be sure. Thanks

From Dave
Posted 4/23/2002 11:05:55 PM
Comments Hi!

We meet on UD fourm when I posted the question on how do i update two tables with one form. You told me to look at your tutorial on how to update. Well, what i wanted to do is insert, it should be very similar. well.... I tried and couldn't get it to work. Could you help me out?

I keep getting this error:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
/Project/admin/frmInsert.asp, line 51

Taking your DB example in tutorial 8, could you tell me how the Command1 code would look like:

SQL:
INSERT INTO ( ????? )
VALUES ( ????? )

Variable:
name run-time Value
??? ????

Thanks for all your help.
-Dave

From kindler chase
Posted 4/23/2002 5:58:09 PM
Comments Hi again Swee Hoe,

I was just taking a look at your Herbalore site.... very nicely programmed BTW..... and thought I'd bring to your attention a minor abnormality you're getting.

On the Category Pages, i.e.,
http://www.herbalore.com/category.asp?cat=3
There is an "lk" showing at the top of the page (above the html tag). Anyhow, thought you may want to know.

Take Care,
::kindler::

From Ross Davidson
Posted 4/16/2002 6:45:48 AM
Comments Dear Sir,

I am a web designer wanting to add a search engine and taylored results pages on my sites. Can Ultra do this is using html pages as the data source eg like a real estate website might do. Or does Ultradev only handle data from databases such as Access??

Hope you can help.

With Thanks

Ross Davidson

http://aliveanimation.hypermart.net

From Bret
Posted 4/12/2002 9:57:11 PM
Comments I am trying to use your tut on filtering 1 recordset against another. I keep getting an EOF or BOF error. I have placed the code exactly as you have shown. Do you have any idea why I am getting this error?

Thanks

Bret

From Hassan
Posted 4/3/2002 11:48:01 AM
Comments Hi,
I have nested repeated region – thanks to your tutorial 9- and it is working just fine. My question is that using UltraDev how can I save the result of nested repeated region in a table? Not sure if I should save in one table or two!
I would appreciated any suggestion and advice
Regards
Hassan

From Duncan
Posted 3/31/2002 4:35:10 PM
Comments I am constructing a site which requires the use of thumb nails(and their details) in a row of four and a column of about ten.

I know how to use repeated regions to represent my database in either rows or columns in Ultradev, but how on earth would I put together a gallery of thumb nails with four in a row and ten in a column?

Your help is much appreciated.

Yours faithfully,

Ultradev. user

From Dayne Ward
Posted 3/27/2002 5:35:41 PM
Comments Hello There,

I've followed a couple of your tutorials with great success but there's
one thing I've been trying to do with Ultradev but just cant seem to get right.

An online shop I'm building (www.littlepeopledirect.com) has four selections in the
girls and boys department to search on.

0-2 years
3-5 years
5-Up years
Accessories

These selections exist in the database in the same column - Group_Desc.

How can I using checkboxes search over the same column in the database. Do all the
checkboxes have to share the same name but the values are then equal to the values
I need to get out of the database column(those above.) A collougue suggested to me I
write the values into a hidden field and send that field as a text search to the resluts
page.

If you could advise I'd be so grateful - I'm completely stuck on this one.

Thanks

Dayne Ward
d@4wardz.co.uk

From Todd
Posted 3/26/2002 7:17:44 PM
Comments Hello,
I am new to ASP and UltraDev and am trying to use your highlighting tutorial. Would it be possible to look at the for search.asp and search2.asp? I'm just not sure where in the page to put the part of the code which calls the function. Thanks.

From Rich
Posted 3/26/2002 6:57:17 PM
Comments I am looking for a tutorial that will help me connect to a DSN and stuff like that... Basicly, I want a tutorial titled "Connecting to a database from scratch"!

You know, the real basics of making the origonal connection, then displaying the information from databases and stuff.

I would also, like to see a tutorial titled "Why you should use a databse on your site" with questions and answers in a FAQ format.

Well, if I am asking to much, tell me and if there is anything I can do to help you (belive it or not I do know some stuf) just give me a shout. I like to help those who help the programming community.

Rich
~Richard Peters

From Joseph Perry
Posted 3/26/2002 7:23:44 AM
Comments I like the E-Mail Tutorial UD40. Now, if I want to insert body text should I replace the objCDO.Body with a referenve to a field in another database table? How do I do this? Thanks

From Donna Lucas
Posted 3/24/2002 11:33:01 AM
Comments Swee Ho,
Another GREAT tutorial. I have been struggling with this for the past week. You make the process so clear! Thanks for all the work you do to help us novices!

From Diane Petring
Posted 3/13/2002 3:08:34 AM
Comments Hi,

I'm new at ASP, but have tons of experience writing queries in Access. Your tutorial at http://www.chronoworks.com/ud40/tutorial9/index.asp was exactly what I needed to get me through a sticky spot! Very clear and understandable!

Thanks!
Diane

From Nuno
Posted 3/12/2002 8:08:19 PM
Comments Im trying to use the tutorial "Filtering a recordset against another", but after I made that, I can't see my area in the repeat region...
I use this and I think Ive put the code in the correct place:

<%
set rsAnuncios = Server.CreateObject("ADODB.Recordset")
rsAnuncios.ActiveConnection = MM_connEncontros_STRING
rsAnuncios.Source = "SELECT * FROM Anuncio"
rsAnuncios.CursorType = 0
rsAnuncios.CursorLocation = 2
rsAnuncios.LockType = 3
rsAnuncios.Open()
rsAnuncios_numRows = 0
%>
<%
Dim rsUsers__var
rsUsers__var = "1"
if ((rsAnuncios.Fields.Item("username").Value) <> "") then rsUsers__var = (rsAnuncios.Fields.Item("username").Value)
%>
<%
Dim Repeat1__numRows
Repeat1__numRows = 10
Dim Repeat1__index
Repeat1__index = 0
rsAnuncios_numRows = rsAnuncios_numRows + Repeat1__numRows
%><%
While ((Repeat1__numRows <> 0) AND (NOT rsAnuncios.EOF))
%> <% Dim varSpecial
varSpecial = varSpecial &_
(rsAnuncios.Fields.Item("username").Value) & ","
%> <%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
rsAnuncios.MoveNext()
Wend
%>
<%
set rsUsers = Server.CreateObject("ADODB.Recordset")
rsUsers.ActiveConnection = MM_connEncontros_STRING
rsUsers.Source = "SELECT * FROM Users WHERE username LIKE '" + Replace(rsUsers__var, "'", "''") + "'"
rsUsers.CursorType = 0
rsUsers.CursorLocation = 2
rsUsers.LockType = 3
rsUsers.Open()
rsUsers_numRows = 0
%>

Before I add the new Repeat Region, I can't see my table inside of the other repeat region, but if I remove the new repeat region, I can see all my records...

Can u help me please?
Thx a lot...

Nuno

From Kindler Chase
Posted 3/3/2002 6:45:23 PM
Comments Hi Swee Hoe Ong,

Thanks for the tutorials - very well written and unambigous! Nice job.

A couple of comments/questions:
1. On tutorial 2 - filtering RS1 on RS2: Perhaps a more effective way of getting the ID from RS1 (instead of adding a second variable:varSpecial) would be to call the ID from RS1 in the runtime value w/: recordset1("ID") - I've used this and it works quite well without having to create a 2nd variable. This is based on the tech note at: http://www.macromedia.com/support/ultradev/ts/documents/filter_rs_by_rs.htm - you still have to adjust the location of the MM created variable, but takes one less step in the end.

2. On tutorial 4 - mailing list. How would you do something similar if you are using the MM insert SB w/ the CDO code above the HTML tags - i.e., same concept as Wayne's tutorial: http://www.ultradevextensions.com/email_after_insert.asp - but being able to send to all the email addresses in your email DB?

Again, thanks for the resource! Nicely done.

Cheers,
::kindler chase::
Roubaix Interactive

From Marc
Posted 3/3/2002 3:30:32 PM
Comments I`m in desperate need of a "LeadeBoard" for a Online golf league. I`m needing players to be able to put there scores in. Then a "leaderboard" page will filter the "Highs and lows" If you know anything about golf and want a new projet please let me know asap I`m in need of this system by March 1 2002 ... Thank you very much

From Paul Le Fevre
Posted 2/25/2002 5:17:46 PM
Comments Hi Swee Hoe, I think your site is very helpful and I have been looking at your Batch Delete tutorial. What I am trying to do is a little simpler but I can't find any help with it anywhere. Wondered if you could.

I want to delete just one record from a database but I want to do it using a menu and a delete button. I have attached the record set to the menu so it lists the records in my simple table and the ID number is passed as a URL parameter to the 'delete' page with the command in it. This part is goes well but I keep getting a syntax error from the delete page as follows:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'branchID = ()'.

/hapkidoPA/delete.asp, line 16


I used "=" instead of "IN" in my command as I am just deleting one record, otherwise, my command is exactly the same as yours.

Also, how can I allow for checking that the record I am deleting is not being used by other tables or records?

Any help would be great.

Paul

From Jackie Johnston
Posted 2/25/2002 10:46:41 AM
Comments Hi,

As a little project, I built an UltraDev/Dreamweaver tutorial directory (at http://www.jackiejohnston.com/ultradev ). There's been some discussion about it on the UltraDev newsgroup and it has been suggested that I ask tutorial writers if they mind my linking to their site. So, I'm asking. I've already linked to your tutorials because they've been so useful to me, but will gladly take them off if you object. Sorry to link first and ask questions later :-)

Jackie

From Dave Bizzigotti
Posted 2/23/2002 6:46:02 PM
Comments hi, i do have one question. i was wondering how to make text boxs look like an image.in other words not like the text box i'm typing in now but just a box like when you join DUresources.com

From mimi
Posted 2/23/2002 12:46:43 PM
Comments Dear Web master

I've started a group called "Webbunch" and it's a collection of all the useful
resources for web masters added to the files and bookmark section. I've added
your file or your link. Please feel free to join the group and share your knowledge
and resources at:
http://groups.yahoo.com/group/webbunch/

Resources includes:
Ultradev, Dreamweaver, Fireworks, Photoshops, Java Scripts, Appletes, etc. and
anything related to the web. I'm sure you will find it useful.

Mimi
http://hatw.net

From Dave Bizzigotti
Posted 2/22/2002 7:37:54 PM
Comments Hi,
I'm sorry i figured it out it was simple as "POST".Dont i feel stupid.Excellent tutorials keep it up D.Bizz

From Dave Bizzigotti
Posted 2/22/2002 7:23:43 PM
Comments Hi,
I tried the batch delete tutorial and i keep on getting this error"Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'mailID IN ()'.

/delete.asp, line 15 "
Please help Thanks Dave

From Parichi
Posted 2/22/2002 5:57:25 PM
Comments Hola amigos, les agradezco por toda la informacion que me facilitan , les estoy muy agradecido, quisiera tener mas comunicacion con algunos de ustedes que quieran para intercambiar experiencias, les saludo un amigo de Peru....bye!!!

From Don West
Posted 2/21/2002 3:10:50 PM
Comments Hi Swee Hoe,
For some reason my two isp servers is now rejecting your email address so I thought I'd try this.

Regarding the SQL question I had for you earlier--
I have decided to start from scratch with what I am trying to do and see if
there is an easier way.
Perhaps you can offer some guidance.

I have a table called images. Each image is assigned a category and
autonumber ID and some other information

On a single page I want to retreive all the category names and list them
individually as a column of links on the left (with repeat region). These
category names would be linking to this same page and passing the category
name (?category=catA ; ?category=catB; etc.) The passed variable would
filter another recordset of the same table (using category) and display the
thumbnail images from the table in another repeat region on the same page.
Those images would be links that would filter yet another recordset of the
same table and present the final, large picture below the thumbnails.
Make sennse??
I'm trying to make this work but I can't seem to make it happen. Do you have
any guidance on how to do this?

Thanks!
DW

From Don George
Posted 2/16/2002 3:54:42 PM
Comments I followed your tutorial #7: Batch update with checkboxes. My site requires this, so I've been working on it for a week. I've followed your code except I've named my checkbox "cbSend". I get the following error when testing:
Microsoft VBScript compilation error '800a03ee'
Expected ')'
/site/inviteprocess.asp, line 13

If(Request.Form("cbSend") <> "" Then

This is the last line in the comClear code. Do you have any ideas? Thanks for any help.


From Shane Anderson
Posted 2/13/2002 6:39:56 AM
Comments Brilliant site. Real KISS in action. Learnt so much. Big thanks mega. A suggestion? Mmm - multiple keyword searches (and can still use your bold highlighting)?

From Shane Anderson
Posted 2/13/2002 6:37:54 AM
Comments Brilliant site. Real KISS in action. Learnt so much. Big thanks mega. A suggestion? Mmm - multiple keyword searches (and can still use your bold highlighting)?

From Jimmy
Posted 2/12/2002 3:28:20 PM
Comments Hi,

Thank you for sharing your tutorial on the nested repeats!

I'm trying to make a menu structure out of this and I have two questions that maybe you can help me on, or point me in the right direction.

1) How would you implement this to be a menu that would allow for drilling down in greater detail. For example you had a field called 'FamousArtist' where this would list a person most famous for a particular 'Instrument'. So, when you clicked on Double Bass you might get Roma Vayspapir.

2) I'd like to have the nested repeats ('Instruments') only be visible if the category heading is selected.

OK, I realize this is a lot to dump on you, so any advice is greatly appreciated.

-Jimmy

From Olly
Posted 2/8/2002 10:21:20 AM
Comments With the batch delete with checkbox tutorial if no checkbox is selected an error occurs on submission what can you do to correct that?

From Helle
Posted 1/31/2002 9:10:03 AM
Comments I really like your site and are comming back every now and then, either to re-read or to see if you've made some more tutorials.
Great job.....:-)

From jason
Posted 1/28/2002 9:27:06 AM
Comments I really like your site!
I loking for a Banner rotator that works with UD4/ I'm using julians at Charon.co.uk but having challenges with building a ratio of impressions column keeping a running tally any suggestions
thanks jason

From Dave Higgins
Posted 1/24/2002 4:41:25 AM
Comments Your tutorials are spot on. Your tutorial number 9 "nested Repeats" has been a lifesaver. And several others - although not used yet - are soon to be put into practice. Please keep them coming. Im sure there are lots of people out there (and here) who welcome these tutorials.

From jhashemi
Posted 1/23/2002 5:17:55 PM
Comments Do you know how to use apple works database with ultra dev.
Apple community are desparate to use Ultra dev . but Macromedia does not support apple in the same way as PC

From Mark Lawson
Posted 1/23/2002 3:20:23 PM
Comments Great tutorials Swee,
As a newbie to Ultradev I appreciate all the useful tutorials that are available! Keep up the good work and keep going with the tutorials!!

From Giorgio
Posted 1/23/2002 8:38:59 AM
Comments How can I create the delete page under JSP? (using UD4)
Thanks

From Mike Wold-Steele
Posted 1/22/2002 11:18:17 AM
Comments Thank you, Thank you..........

Your tutorials have saved me a bunch of time and really helped me get a better understandingof more advanced UltraDev programming!!

I search all over for a tutorial like number 6 and could not find anything!!!

Once again Thanks!!!

Mike

From Denis
Posted 1/22/2002 4:21:12 AM
Comments This is the second feedback from me. Somtimes ago I tried to use tutorials 6 and 7. It works fine. Now two days I try to make multipleupdate using Your tutorial 10. I can't undestand what's wrong with code I wrote.

This is the error message I get every time: Missing operator in query expression WHERE Code =

This is the code I wrote on update page:
<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="../Connections/DBICCI.asp" -->
<%

if(Request.Form(".Name") <> "") then Command1__varText = Request.Form(".Name")

if(Request.Form(".Code") <> "") then Command1__varCode = Request.Form(".Code")

%>
<%
If Request.Form("Submit").Count > 0 Then
Dim iCount, iLoop, varText, varCode
iCount = Request("tCnt") 'iCount is number of records to be updated

set Command1 = server.CreateObject("ADODB.Command")
Command1.ActiveConnection = MM_DBICCI_STRING

For iLoop = 1 to iCount
if (Request (iLoop & ".Name") <> "") then Command1_varText = Request ( iLoop & ".Name")
if (Request (iLoop & ".Code") <> "") then Command1_varCode = Request ( iLoop & ".Code")
'Mark empty textfields as MISSING
If Len (Trim (Request (iLoop & ".Name"))) = 0 Then Command1_varText = "NO ENTRY"

Command1.CommandText = "UPDATE Personal SET Name = ' " + Replace(Command1__varText, "'", "' '") + "' WHERE Code = (" + Replace(Command1__varCode, "'", "''") + ") "
Command1.CommandType = 1
Command1.CommandTimeout = 0
Command1.Prepared = true
Command1.Execute ()
Next
set Command1 = Nothing
Response.redirect ("terminal.asp")
End if
%>
If You'll have time to find my mistake. Please help me.
Thanks in advance. Denis.

From Jarrod Ruez
Posted 1/13/2002 12:23:11 PM
Comments Your tutorials are great! I was looking for a quick example of deleting and updating multiple database records and found this site. I read through the tutorials and created the pages in a matter of minutes. You just saved me a ton of time. Thanks for the help!

From Travis
Posted 1/10/2002 10:07:06 AM
Comments Good morning - I have used the update to two tables tutorial very successfully - however when I attempt to substitute an Insert statement - it tells me that there is a Syntax Error in the statement - which is below;INSERT INTO Table1 Set One = '" + Replace(Command1__varOne, "'", "''") + "'"

Any help would certainly be greatly appreciated!!!

From Denis
Posted 1/8/2002 10:04:38 AM
Comments Thanks a lot for your tutorials. I`ve spend a month trying to delite repeated regions by checkboxes, before I`ve seen your site. It`s so easy!!! Thank You!

From adam
Posted 1/8/2002 6:38:05 AM
Comments great site !,

im looking at the tutorial http://www.chronoworks.com/ud40/tutorial8/index.asp and was wondering how do u setup the stored procedure to add more than one field to a record ?

From Jackie Johnston
Posted 1/7/2002 12:50:20 AM
Comments Thank you, thank you, thank you! Your tutorial on how to filter one recordset based on the filtering of another was what I've been trying to figure out for two days now. I'm so glad I found your site and so glad that you wrote the tutorial.

From Edward
Posted 1/2/2002 1:08:06 AM
Comments Hi there,
Please kindly help. Currently I have an Access database that contained two tables. There is a relationship between this two tables (one to many). How can I delete a record in the first table which have many records in second table linked/related to the record in the first table?

From Anon
Posted 12/16/2001 7:43:55 AM
Comments Great (and really really helpful) site.

Simple and elegant :)

But what would make the site complete? - A tutorial on Inserting Multiple Records into the one Table.

Keep up the effort.

From Don West
Posted 12/14/2001 9:26:43 AM
Comments Finally! Someone is posting tutorials of solutions to REAL problems! Thanks a million for doing this Swee. I have pulled my hair out many times ove what seems to be the simplest of needs and no one post information on how to solve it. This is the stuff you don't find discussed in ANY book.
PLEASE! Keep up the good work!

From Karl
Posted 12/13/2001 8:32:37 PM
Comments The pages are cut off at the right hand side. Sometimes its difficult to know whats going on if half the code is missing.

From luis aspuru
Posted 12/12/2001 10:35:21 PM
Comments great tutorials!!!!

From Tommy
Posted 12/10/2001 8:08:08 AM
Comments Firstly great site very clear tutorials.

I have just used the "Batch delete with checkboxes" witch works fine however I also wish to delete the image that the record references to. ANY CLUES??

Many thanks

Tommy

From Ric
Posted 12/7/2001 7:41:34 AM
Comments Hi, I&#8217;ve just done your tutorial on filtering one record set from another. However I have one slight question.

How do I get it to filter the second record set from the first , when the first receives multiple values? When I try this it only filters the second record set on the first value that is got from the first record set.

My first record set, (RS1) gets a list of values from the database, I then want to use all these values (not just the first value that I am currently only able to get) to filter the second record set (RS2) for values from another database table that shares a common filed with the table from RS1!

Hope this make sense

Thanks for your help

Ric

From Jade
Posted 12/4/2001 4:48:09 AM
Comments This is a great site.The layout is clear and easy to navigate.However, it would be great if you could insert more extensions that we can use.
Cool man.

From Steen
Posted 11/28/2001 3:28:58 AM
Comments Hi There
tryin to make the nested repeat tutorials :

is there some code missing on the right of your page, where the code says Then%

I can`t get it to work and the
top cell from my table goes away.

Please Advise

Regards Stone Jensen

From omar
Posted 11/28/2001 2:21:21 AM
Comments i was just checking in.
great job with the tutorials swee!

From James
Posted 11/24/2001 8:18:59 PM
Comments I really like your tutorials :)

From ed hingston
Posted 11/19/2001 4:28:45 PM
Comments Hi Swee!

thanks for getting back to me I wanted to know script wise how do I combine the month day and year to be inserted into the db field.
Is a for next loop needed or just combining the strings with '+''s

thanks ed
p.s.
check this tutorial out I don't remember exactly where I found it
http://rjnet.dhs.org/ultradev/

From ed hingston
Posted 11/17/2001 4:28:53 PM
Comments Hi Swee Hoe Ong,

Thanks for sharing your insights on ud4. My question is; using access 2000 how do you get someone to enter their date of birth. In the require access format.(Date/Time)
MM/DD/YYYY (set on a us server).
I would like to use drop down boxes similar to your tutorial, but using an form each box would insert into the Date of birth field in the mdb. Can I have three form objects inserting into one date/time field.

any solutions aside from prompting the user to follow access form with a simple text box but this would run the risk of error if someone entered the year first for example...

thanks in advance
ed
"Komosumidah"

From Pat Meeks
Posted 11/16/2001 3:25:19 PM
Comments I just wanted to say thanks for the tutorials. They are so well done.

Newbie ASPer

From Hassan
Posted 11/15/2001 6:39:39 PM
Comments Hi,
I like to use your tutorial 8. but for some reason where it says add by hand code ..the picture s are cut off. And I am not sure what the words are.
I would appreciated If you could provide me the code
Thanks
Hassan

From Mark
Posted 11/15/2001 5:16:21 PM
Comments It's good to see people happy to share their knowledge. I've just used your 'Update Repeat Region' tutorial and after fixing a few silly errors I made it works great.
Thanks for taking the time to make these tutorials available.
Mark

From Donna Lucas
Posted 11/12/2001 9:04:36 AM
Comments Swee Hoe,
Your tutorials are great! A lot of information here that I haven't seen anywhere else. I am eager to try the Mailing List and Batch Delete using Checkboxes. Thanks for putting in the time and effort it took to develop these tutorials!

From Olly
Posted 11/8/2001 5:33:23 AM
Comments Hello,

I think your site is very helpful and I appreciate the work.
For the example on Update repeated region could you send me the code on the first page as I am having difficulty getting mine to work.

I think the confusion comes with the hidden fields.

Thanks

Olly..

From Brad Lawryk
Posted 11/6/2001 5:11:35 PM
Comments Hey, great tutorials!!! I have learned a lot just by reading them over. Glad I found your site in one of the posts inthe Macromedia Newsgroups. Iwill be usingyour site for a refence point over and over. Keep up the good work!

From James
Posted 11/6/2001 3:55:48 PM
Comments in your example: Tutorial8 updating record sets in different tables, how do you call the record id? I have 2 tables, and each has an ID field (which is generated numericaly) as well as an email field. I want to update table1 with some data for the record that email="bob" (for example) and table2 update some different data where table2 email="bob". What I want to know is first, how do I move to that record in both tables and second, how do I use the forms e-mail field for 2 different insert commands (in my mind, somehow I need to mirror the info into a second form field ID.. Does this make any sence?

From Raj
Posted 10/24/2001 8:43:44 AM
Comments Swee,

Thanks for the excellent tutorials on your site! You are doing an excellent job.

How would I use a nested repeat region behavior to create a sitemap derived from a database.

My sql database is as follows:

Menu Table:
-----------
MenuID
MenuParent
MenuName


Basically, I want to accomplish the following:

Corporate (main nav item - grandparent)
- About Us (parent)
- Careers (parent)
- Benefits (child)
- Current Openings (child)
- Our Culture (child)
- Partners

Solutions (main nav item - grandparent)
- Solution 1 (parent)
- Solution 1a (child)
- Solution 1b (child)
- Solution 1c (child)
- Solution 2
- Solution 3

Serivces (main nav item - grandparent)
- Service 1(parent)
- Service 1a(child)
- Service 1a(child)
- Service 2(parent)
- Service 3(parent)

etc....

Each menuID has a MenuParent, but if the parent is 0,
then it is a top-level navigation item (a grandparent).

Thank You,

Raj

From Søren Bech
Posted 10/22/2001 4:59:22 PM
Comments Can you make me an example of your simpel email list, using Jmail instead of CDonts ?
I hav e tried for some time now and cant get it to work.

From Doug Miller
Posted 10/17/2001 10:19:03 AM
Comments I have used a couple of your tutorials and wish to thank you for the time you put in.

From robert egan
Posted 10/11/2001 5:13:54 AM
Comments Hi you responded to my feedback and my query regarding the tutorial "Batch update with checkboxes". I was wondering if you spotted the error message in my code i sent back as requested, last friday.

cheers

rob

ps if you didnt recieve it from
rob_j_egan@blueyonder.co.uk just pop me an email and I'll email it again later tonight.

thanks again rob

From Hassan Rostami
Posted 10/10/2001 1:22:05 PM
Comments Hi Swee;
My Name is Hassan I have used your repeated region tutorial it was very easy for me to follow and completed it successfully and I have to say Very Nicely Done Job I wish you luck and succeed in completing this tutorial to the point that your site will be all UD users resource.
.
Now I have a question, which I hope you could help me out with. Here is my case.
I have repeated region, which is a table with two rows top one, is Items, and bottom one is Parts. This page upload with regard to the search page, which has Sales Order number and Machine Type. Sales Order number is text field and Machine Type is drop down.
In my result page I want to show Photo of the Items and Parts. Photos are in Folder call Images. Each Items and Parts have a unique number which is the name of corresponding Image file. For example Item number 123 has image file named 123.jpg and Part number 456 has image file named 456.jpg.
Now how can I do the following task:

1- If no selection in Machine Type, I show corresponding Item image, but if there is a selection I have to show corresponding image file regarding to the that machine type ( Which in way machine Type is an item listed in my database) only in the FIRST filed on my repeated region
2- If there is no image in the folder show this photo, NOPHOTO.JPS

I would appreciated your help please send you response to hrostami@smsocs.com


From Olly
Posted 10/6/2001 1:15:34 PM
Comments Your site is great but could you explain the Filtering a recordset against another tutorial more clearly.Step by Step.

From robert egan
Posted 10/5/2001 8:13:03 AM
Comments Love the site, managed to do the batch delete, but no the batch updating example, i enclude my source code

<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="Connections/Update.asp" -->
<%
set comClear = Server.CreateObject("ADODB.Command")
comClear.ActiveConnection = MM_Update_STRING
comClear.CommandText = "UPDATE Tutorials SET Status = 0"
comClear.CommandType = 1
comClear.CommandTimeout = 0
comClear.Prepared = true
comClear.Execute()
set comClear = Nothing
If Request.Form("Checkbox") <> "" Then
%>

<%
if(Request.Form("Checkbox") <> "") then comUpdate__varSelect = Request.Form("Checkbox")
%>

<%
set comUpdate = Server.CreateObject("ADODB.Command")
comUpdate.ActiveConnection = MM_Update_STRING
comUpdate.CommandText = "UPDATE Tutorials SET Status -1 WHERE ID IN (" + Replace(comUpdate__varSelect, "'", "''") + ")"
comUpdate.CommandType = 1
comUpdate.CommandTimeout = 0
comUpdate.Prepared = true
comUpdate.Execute()
set comUpdate = Nothing
End If
Response.redirect "page1.asp"
%>

<html>
<head>
<title>page2</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body bgcolor="#FFFFFF" text="#000000">
</body>
</html>

My error message is as follows:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.

/page2.asp, line 26

Hope you can help, regards

Rob

From Giuseppe
Posted 10/4/2001 1:01:03 PM
Comments Hello,
your mailing list tutorial is very nice.
Just a question: where we write the text to send all recipent email?
I can't see any details about it.
Thank you for answer
Ciao
Giuseppe

From Lon Wilkosz
Posted 9/7/2001 4:04:45 PM
Comments I tried your batch update instructions and it works nicely. I want to thank you for your information. I have spent hours searching for information on how to do a batch update. You have solved this problem since ultradev 4 does not currently do this. I am involved in a project that this was needed. Thanks again :)

From Romek
Posted 8/21/2001 4:52:46 AM
Comments I wonder, do You intend to write some next tutos. So far everything seems to be OK - spendid idea and some hard work. Have You ever thought about tutorial about advanced authorization in UD4?
Take care, Roman

From Jorge
Posted 8/15/2001 6:41:31 PM
Comments Hi, you tutorials were very useful for me. I used your delete using check boxes tutorial and works great. Then i tried to do something similar using a Select SQL sentence. I know that i can make this: "SELECT * FROM table where ID IN (variable)" because it works when i use it with entered vaules (2,5,7), the problem is when i try to use a request form or querystring variables because it doesnt works anymore. Can you do this? how? I thank you for any help that you can give me.
(sorry for my english)


From Dooza
Posted 8/13/2001 11:19:26 AM
Comments Just used your mailing list tutorial and its great. You should submit this tutorial to www.udzone.net as it is really needed.

From Kevin Williams
Posted 8/9/2001 8:03:36 AM
Comments The final code located at the bottom of Tutorial 7 - Batch update with checkboxes, is cut off. I was wondering if you could repost what it is or let me know what it is. Thanks.

From Frank Basti
Posted 8/8/2001 6:20:42 PM
Comments YOU ARE A GOD!
This is the most usefule stuff ever!

Tutorials on your cart would rock also

Frank

From h
Posted 8/5/2001 6:37:18 PM
Comments Hi

Used your multiple deletes tutorial and it was reall good... thanks so much.

However, I could managed to get the multiple updates working too... however I want to update multiple fields that are equal to the value of my text boxes (typed) from the prvious page.. Does that make sense...

If so I'd appreciate any pointers...

Great tutorials... thanks for the hard work - its appreciated

H

From Daved
Posted 7/31/2001 12:17:06 PM
Comments I wonder if you could help me. I'm trying to set up a mailing list app using the code you've put up. Its the best I've found since it puts the address of each individual into a new mail rather than list them all in the To: box.

My question is this. How could I specify the body of the message as the value of a form textbox entry. So you have a textbox into which to type the body of the message then a submit button that posts that info to the mail.asp

The reason I ask is because I want to send HTML formatted emails and copying and pasting the HTML souce from somewhere else still has lots of spaces and line breaks and just wont work.

Thanks in advance

Daved

From mark davies
Posted 7/30/2001 9:03:58 AM
Comments I have downloaded DUforum from duresources.com and have tryed to use your update checkbox tutorial
All works great but it up dates all 3 forums rather than just the 1, I define them by FORUM_ID, but on the command window i dont know how to say WHERE FORUM_ID = Request.String("FORUM_ID")
COuld you tell me the correct procedure i need to use ??
Thanks very much
Mark
P.s. keep up the good work, it's helped me no end!

From Scott
Posted 7/28/2001 1:39:35 PM
Comments Hi Swee Hoe,

I heard about your site in the Ultradev newsgroup. I just wanted to let you know that I really enjoyed your tutorials. I'm currently working on my first Ultradev site (http://www.digifreq.com/digifreq/) and your tutorials have shown me how to accomplish some things I didn't know how to do.

Thanks!
Scott

From Chris
Posted 7/17/2001 7:34:33 AM
Comments Why dont you have server side vaildation for this form? Could be used as a tutorial.

C.

From Kevin Marshall
Posted 7/16/2001 10:46:52 AM
Comments In your tutorial Tutorial 8 - Update records in different tables, we add the line Set Command1 = Nothing.

I was wondering what this means. What exactly does it do?

I know this is a feedback form, not a help forum, but I'd be grateful if you would let me know.

Regards
Kevin

From glen
Posted 7/14/2001 9:47:07 PM
Comments hi i need some help in creating library site. i have no problems displaying, deleting or adding books my only worry is that i need to show what books a particular student has borrowed and also if that student does not return the book with in 30 days then an email needs to be sent out and also a penalty of $1 for each delayed day. could you explain the most efficient way to do this, say adding a students table or something.

From Antonio
Posted 7/5/2001 12:18:16 PM
Comments Fantastic, very usefull and clearly explained.
I need i bit more about variables SQL and database in order to been display in results pages

From ilan
Posted 7/5/2001 9:42:49 AM
Comments your sit is good

From Travis Brown
Posted 7/3/2001 10:51:29 AM
Comments I like the nested repeat tutorial; however, I was wondering if you could expand it to show how to filter child tables as the nested repeat region based on the parent repeat region results?

From Matt
Posted 7/1/2001 4:09:36 PM
Comments Thanks for your help on passing dropdown list values to a text box. I thought I would visit your site, your tutorials are easy to follow and are a superb help!

From Urban
Posted 7/1/2001 3:13:09 PM
Comments Hi!
I have a question, how are we supposed to copy and paste the code in Highlight searched word tutorial?
It´s an image! ;)

From Jessica Hill
Posted 6/28/2001 4:49:30 PM
Comments I am referencing your tutorial to update repeated region. When I implement the code on my own page, it does the update, but times out and enters the same company name to every company.

From Richard
Posted 6/25/2001 9:26:48 AM
Comments Very excellent site with great and useful tutorials. I appreciate you sharing your knowledge. Thanks!

From Ernie.DeVries
Posted 6/19/2001 5:20:48 PM
Comments Your tutorials are very helpful, but would be even more helpful if the screen captures weren't cut off on the right side.

From Jeremy Conn
Posted 6/18/2001 12:18:48 PM
Comments I wanted to drop you a line and thank you for your tutorials... you are very generous to share your knowledge - they are all very helpful. Thanks again.

From Vladimir Bien-Aime
Posted 6/4/2001 1:23:54 PM
Comments Tutorial 9 - Nested repeats
In step 3 which reads ..

Step 3.

Now for the coup de grace. Add in by hand the codes in line 111.

Don't you mean line 114


From Gooks
Posted 6/4/2001 7:16:24 AM
Comments Very clear and concise tutorials - wish I had come across them much earlier!

From Bhavesh
Posted 5/30/2001 9:16:03 PM
Comments Hi,

I was trying to use your nested loop tutorial, but it did not work for me. I got this error:


Microsoft JScript compilation error '800a03ec'

Expected ';'

From Shane Bennett
Posted 5/30/2001 4:08:26 AM
Comments Hi - I am looking for a tutorial on Boolean Searches - Do you have one

From Jeremy Conn
Posted 5/10/2001 4:39:43 PM
Comments This site is great... thanks for sharing your experience with us. - JC

From Greg Cathcart
Posted 5/10/2001 9:13:26 AM
Comments Terrific resource, keep up the good work!

From alexis
Posted 5/10/2001 7:08:07 AM
Comments Hi Swee,

Please could you help me with tut 10.. i cant make it work at all...

I can trade you something maybe?

:o)

Alexis

From al
Posted 5/10/2001 5:46:38 AM
Comments just cannot get Update repeated region to work at all..

arghhh! your tuts are great ! but this one is really essential and the actual command bit is the most important, please please make it step by step sir!

Thanks very much

From Ada
Posted 5/10/2001 5:16:12 AM
Comments i've tried your repeated regions tutorial again- i really need this to work but don't know what i've done wrong. if you can email me i can send you the test page i made. thanks!

From Patricia Meeks
Posted 5/4/2001 9:14:45 PM
Comments Just starting out with UD...but I'll be back to work through some of the tutorials. Thanks very much for the site. I can't comment on the tutorials because I haven't tried them yet <g>.


From Peter
Posted 4/12/2001 1:38:00 AM
Comments I am getting this error... from the nested region tutorial, this works with Javascript right?

Microsoft JScript compilation error '800a03ec'

Expected ';'

/testing/index.asp, line 40

Dim strHeading
----^

From Ada
Posted 4/8/2001 11:34:11 AM
Comments in the nested repeat tutorial Step 3 - it didn't make sense - where you have "rsEmployees..." - is that supposed to be Recordset1? i tried that but it still didn't work. Any ideas why it didn't?
thanks

From George Petrov
Posted 3/14/2001 11:42:05 AM
Comments Hi Swee,

Cool tutorials! Great work!
Would you like to post your tutorials on www.UDzone.com? This will be a great contribution to the UD community!

Thank You!
George Petrov
www.UDzone.com

From max hazelhurst
Posted 3/9/2001 11:46:18 AM
Comments Cool tutorials. Nice and concise and not heavy reading. Thanks!

From Asihan
Posted 3/6/2001 4:44:18 AM
Comments Hi,
I was trying to INSERT two value to two table as you pointed out in you 'Update records in different tables', but how do I deal with AUTO number field? what value should i assign to ID?
thanks Asihan

From Asihan
Posted 3/5/2001 6:55:22 AM
Comments Hi,
great tutorails, keep going.
all the best,
Asihan

From Joe
Posted 3/2/2001 2:56:10 PM
Comments excellent tutorials, especially the one with the multiple deletes with checkboxes

From Tarcila
Posted 2/21/2001 7:27:17 AM
Comments Thank you. This tutorial is very very good.If you had a banner I click may times there to pay your work ;)

Carlos
Spain

From Waldo Smeets
Posted 2/20/2001 7:20:24 AM
Comments Hi Swee Hoe Ong,

interesting site you've got here. Are you interested in linking/uploading your tutorials at www.UDzone.com ?

Waldo
UDzone.com Webmaster

From Warren G. Beatty
Posted 2/7/2001 11:45:43 PM
Comments Just wanted to compliment you on your tutorials. I was in search of Batch delete coding, and your tutorial was easy to understand, and within 15 minutes I had everything working the way I wanted. Thanks.

From rodrigo salinas
Posted 2/1/2001 1:14:23 PM
Comments how can I display the current date and time. I'm using UD4. I learned about you on the UD newsgroup. thanks.