Search results for query: *

To clarify, The commas that are &quot;floating&quot; are the ones between authors' names (the one between LastName, FirstName is fine, thanks perhaps to the Trim function) and the one preceeding eds. (the code is for &quot;, eds.&quot;). Oddly enough, for this chunk of code: <cfif...

I am using the trim function, so that does not seem to be the issue. Here is an example of the output: Farber, H. S. and J. Gowa. 1996. &quot;Polities and Peace&quot;. In Debating the Democratic Peace: An International Security Reader. Brown, M. E. , S. M. Lynn-Jones and S. E. Miller ...

I am trying to output bibliographic entries. The number of authors and their relative positions determines a variety of factors, such as &quot;LastName, FirstName&quot; versus &quot;LastName, FirstName,&quot;, &quot;FirstName LastName,&quot; or &quot;and FirstName LastName&quot;. The same...

Is there some way to reference an anchor tag in the cfform tag? I have a long iterative form and would like the user to return to the appropriate part of the form rather than the top of the page each time an element in the form is submitted...

Haven't worked with cfmodule before. If I include the form template in the template attribute, how will I pass the parameter values? Also, will this act like a cflocation in taking the user back automatically? Thanks for the suggestion.

twcman, Yeah, I had thought of that too. Thus far I have avoided using session variables for this particular site and was hoping to keep that up but I may need to use them or have an additional form and pass them as hidden (which is what I have built in the interrum; annyoing but it works)...

Yeah, that's a cf 5.0 feature and I am running on 4.5. Any other ideas?

I have a long iterative form to build a large record submission (the information must be finalized prior to submission so iterative submissions are not possible). However, the user may need to exit from that form to add some additional data to the database, then return to the original form and...

Tek, What works, of course, and I am doing currently is that in the Biblio table I give each entry a PrimaryAuthorFirstName and a PrimaryAuthorLastName. This works fine for the initial sort, but I am replicating data so it seems that there should be a better way, no? Thanks anyway for your...

If you look at the error, it cannot convert the datatype varchar to datatype money. What is the datatype of your form field? Try making it numeric (maybe prepopulate with a 0 if that is appropriate) and, if it is a cfinput you can validate a numeric data type. Then, in your insert/update...

You need to make sure that the datatype of the field in table 1 is the same as the datatype of the field in table 2. Otherwise, you need to convert the data. Glad you solved the other issue. Is this problem part of the same process?

Hmm, Are you trying to create a table with an edit function for each record? If so, you need to create a form for each record in which you pass the relevant information when the form is submitted. You can do this easily enough with a cfloop. Is that what you have in mind?

Okay, First, the output is simply a list of bibliography entries that need to be sorted by AuthorLastName: AuthorLastName, AuthorFirstName, SecondAuthorFirstName SecondAuthorLastName,... Year. Title. PublisherLocation: Publisher. This list of entries is generated by selecting a subject. Here...

Two options: 1. SELECT ArCustomer.Customer, ArCustomer.Name, p.name FROM dbo.ArCustomer, DynoOwnerRec.dbo.TuningLinkIssues p WHERE p.Customer = dbo.ArCustomer.Customer AND (ArCustomer.Customer = '0013746') OR 2.SELECT ArCustomer.Customer, ArCustomer.Name, p.name FROM...

What is the relationship between the two tables? I think you need to include a where clause like ArCustomer.Customer = p.Customer. Alternatively, use a Join statement (which will also require that you stipulate the connection between the tables).

I have tried to resolve this problem both using SQL and using various CF tricks to no avail. I am running an Access DB on a CF 4.5 platform. I am generating a bibliography from a database. When a subject is selected (SubjectID) a list of books is generated using a subquery, as there is a...

Worked like a charm! Just for my own edification, why did the double quotes work in Access but cause the problem when passed in the template, since I am using Access functionality in the template? Again, thanks a lot!

I assume this is just a typo, but your code above has <img scr=, which should be <img src=.

Can't seem to figure this one out. I need to select all records in the table based on a user-input year; the date/time field DateReceived contains a full ODBC date. Oddly enough, I get a &quot;too few parameters&quot; error through my CF template, but the query works fine in Access (when I...

Doh! I knew it had to be simple... Thanks thlawkins! Now I can try to have a little fun... profwannabe