How to use a select list result to query a table to populate a textarea

[Spoogledrummer]

Hi, I'm a total novice to ASP (yesterday was literally the first time I looked at it) but am currently working on an application that will send an e-mail to selected users, the text that goes in the e-mail will be displayed in a textarea and will be loaded from the database but is editable. The text loaded into the textarea will be selected from a select listbox which is populated by the database (I've actually managed to figure that bit out).

What I need to do is figure out how to read the result of the listbox, then use that to query the database and populate the textarea. I was convinced it would be fairly easy as I expected Visual studio to do everything but apparently that's not the case when using SQL 7.

Any advice would be appreciated, it's getting pretty frustrating knowing that this should probably only take an hour or so yet so far I've spent 2 days searching Google and only got half way.

On a side note is there any way to get the search feature on this forum to only search the ASP section?

[shweta123]

Hi,

Can you please mention more details about

1) How are filling the listbox and Textarea ,I mean are you using the same tables to fill them.

2) The TextArea is containing emailText I think but what your listbox is containg?

Hi, I'm a total novice to ASP (yesterday was literally the first time I looked at it) but am currently working on an application that will send an e-mail to selected users, the text that goes in the e-mail will be displayed in a textarea and will be loaded from the database but is editable. The text loaded into the textarea will be selected from a select listbox which is populated by the database (I've actually managed to figure that bit out).

What I need to do is figure out how to read the result of the listbox, then use that to query the database and populate the textarea. I was convinced it would be fairly easy as I expected Visual studio to do everything but apparently that's not the case when using SQL 7.

Any advice would be appreciated, it's getting pretty frustrating knowing that this should probably only take an hour or so yet so far I've spent 2 days searching Google and only got half way.

On a side note is there any way to get the search feature on this forum to only search the ASP section?

[Spoogledrummer]

Hi, yes both the listbox and textarea are hitting the same table, I've made a little progress on it though have included an extra button now too. My code is as follows:

<%
Dim strEmailType
Dim strContents
strContents=NULL
strEmailType= NULL
%>
<%
set objconn=server.CreateObject("ADODB.connection")
objconn.Open ("DSN=localserver; User ID=User; Password=Pwd")
set rs2=objconn.execute ("SELECT * from Grades_email_tbl")
'set rs3=objconn.execute ("SELECT emailContents from Grades_email_tbl WHERE EmailType ='"&strEmailType&"'")
%> 
<% 
strEmailType = Request.Form("Select1")%>
<%
If strEmailType = "Failed" then
     strContents="Bah"
Else
    strContents=rs2("emailContents")
End if
%>  
<form method="post">
 
<select name=select1>
 
<%do while not rs2.eof %>
<option><%=rs2(0)%></option>
<%
rs2.movenext
loop
rs2.Close 
set rs2 = nothing
objconn.Close
set objconn=nothing
%>
</select>
<input type=Submit value=Go! />
&nbsp;
&nbsp;
<br />
<textarea style="width: 561px; height: 60px" id="emailtxt">
<%=strContents%>
</textarea>
</form>
<tr><td align="center"  colspan="8">
    <input id="Save" type="submit" value="Save" />
    <input type="submit" value="Send" name="submit1">
</td></tr>
</table>
 
</body></html>
 

At present the listbox populates fine and I've managed to extract the value and place it into the variable strEmailType, what I can't seem to do is get the value emailContents that corresponds to the selected option from the dropdown. I'm trying to get it from the recordset rs2 but at present it only displays the first record from the table, I know I could hardcode it for a quick fix but I'd rather future proof it a bit.

I'm thinking about taking the value of strEmailType and querying the database to return the value of emailContents I want but I'm convinced I can get the value from the rs2 recordset, afterall it should have selected all the information from the table.

The most frustrating thing is knowing it's probably a 2 minute fix

[jhardman]

On a side note is there any way to get the search feature on this forum to only search the ASP section?

No, sorry. We keep bugging the administration but to no avail. You could post to that effect in the feedback section.

Jared

[jhardman]

I really like to take this type of thing one step at a time. First off check to make sure your form inputs are being submitted to the next page like this:

dim x
for each x in request.form
   response.write x & ": " & request.form(x) & "<br>" & vbNewLine
next

Then make the appropriate SQL query:

dim query
query = "SELECT emailContents FROM Grades_email_tbl WHERE EmailType ='"&strEmailType&"'"

Then print out the query to make sure it looks right:

response.write "query: " & query & "<br>" & vbNewLine

Then open the dbconnection:

set rs3 = server.createObject("ADODB.recordset")
rs3.open query, objConn

Then put this in the textarea:

<textarea id="emailtxt"><%=rs3("emailContents")%></textarea>

Try out these steps and see if this works for you.

Jared

[Spoogledrummer]

Thanks very much, that's got it working. Sorry about the delay in replying but I couldn't test it at home as I'm still setting up visual studio to work with SQL 2005 on Vista which has started to turn into a nightmare, especially with IIS 7 thrown into the equation.

[Spoogledrummer]

No, sorry. We keep bugging the administration but to no avail. You could post to that effect in the feedback section.

Jared

Just found this by chance:
http://www.thescripts.com/forum/search.php?
Not quite sure how I got to that link but it allows me to select just the ASP forum for a search