Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
-
line breaks- store in DB
Hi, I have a text area that will put it's text in a DB. Later the text will be displayed on the website but not in a text area. How do I store the data so that the line breaks are on the website. How do I replace the text area breaks with <br>? Thank you for your help. Ryan -
auto display DB fields
Thanks a lot. Your loops worked great for me. I had to substitute the query name for the places you had the table name. I also added cfoutput tags around #i# for the column names. Thank you! Ryan -
auto display DB fields
Hi, Is there any way that I can have coldfusion automatically display all the fields that I select? Example: select * from mytable Then have it display all the fields from mytable (in html table format) without having to name them all. Please let me know. Ryan -
cflocation and forms
Thanks. I used cflocation and just put the variables in the url instead of form. -
cflocation and forms
Hi, I like how cflocation can redirect a page, but it's still easy to go back: it doesn't redirect again (just skips the redirect page) and make it difficult to go back. I'm wondering if there is something similar that I can use to submit a form so that when the user presses the back button, it... -
drop down box determine next page
Hi, Is there any way to change where a form is submitted to based on the option that is selected in the drop down box? It's the only item on the page, and it should go to a different page based on what option is chosen. Perhaps it can be done with javascript? Thank you for your help! Ryan- ryanbrand
- Thread
- Replies: 1
- Forum: Javascript
-
-
bad formatting table cell
One of my table cells isn't letting the width be fully used up. It acts as if there's a 2 inch margin on the right side of one of the cells. Could you help me fix this? The code is below. Thank you!! Ryan ------------------------------------------ <html> <head> <style type="text/css">...- ryanbrand
- Thread
- Replies: 2
- Forum: HTML, XHTML & CSS
-
-
combining tables
Hi, I have an updating issue with my one of my database tables. I have an old table with fields that are accurate, except for one of the fields. I have another table that has the same records (plus many more) with the correct information in the field that is outdated in the other table, but... -
create javascript variables on the fly
An array will work perfectly. I don't know why I didn't think of that. Thanks a lot. Ryan- ryanbrand
- Post #4
- Forum: Javascript
-
create javascript variables on the fly
Hi, I would like to create an undefined number of variables as my page loads. I want to use numbers to change the name of the variable. Here's how it would work: 1. declare variable 2. create new variables in a loop Afterward I would have a list of variables depending on how long the loop goes...- ryanbrand
- Thread
- Replies: 4
- Forum: Javascript
-
Text area format editing
Thanks for your information. I think I want to stay away from having tags inside the text box, so I'm going to try the Xstandard and see if that suits my needs. Thanks again for your ideas! Ryan- ryanbrand
- Post #4
- Forum: HTML, XHTML & CSS
-
Text area format editing
Hi, I'm creating a form with a text area. I would like my users to to be able to format their text (bold, italics, color, font). Then I would like the text and formating to be saved into a DB. Then be displayed with the formatting. Is there any code that can let my users (non-coders) format...- ryanbrand
- Thread
- Replies: 3
- Forum: HTML, XHTML & CSS
-
Joining tables
Hi, I have a complex database issue. There are 3 tables that I have to join. Here are what the tables look like: TABLE: MajorListings MajorName MajorCode ---------------------- Pre-Med XBIO History HIST Theology THEO TABLE: studentInfo studentID StudentMajorCode... -
Join Tables in CFQuery
Thanks for your help... I just might have to change my database to have the codes and the names in the one table. I have Access 2000, so I don't understand why it won't work. It won't be too difficult to add the names in, but the design won't be as good. That's ok though. Thank you. Ryan -
Join Tables in CFQuery
That's correct that it is an access database and I'm using ColdFusion. Here's the query: <CFQUERY datasource="#DB#" name="joint"> select ucode , p1.name as person1name , p2.name as person2name , p3.name as person3name from areas left outer join counselors... -
Join Tables in CFQuery
Rudy, I don't know what you meant by ColdFusion query-of-queries, but I'm using ColdFusion to get this information and display it on my page. When I tried the code it gave me a syntax error. When I only had it try to left join with one of the people, the error was "Join Expression Not... -
Join Tables in CFQuery
Hi, I have 2 tables that I have to get data from. The first table will determine what data is pulled from the second. The problem is that I need to pull 3 records for each record pulled from the first. Here's an example of the tables: TABLE: areas areaID personcode1 personcode2 personcode3...
