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!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. profwannabe

    Cfif causing extra spaces in output

    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...
  2. profwannabe

    Cfif causing extra spaces in output

    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 ...
  3. profwannabe

    Cfif causing extra spaces in output

    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...
  4. profwannabe

    Pass anchor reference in cfform action field?

    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...
  5. profwannabe

    passing form parameters with CFLOCATION?

    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.
  6. profwannabe

    passing form parameters with CFLOCATION?

    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)...
  7. profwannabe

    passing form parameters with CFLOCATION?

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

    passing form parameters with CFLOCATION?

    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...
  9. profwannabe

    Sorting on results from many-to-many relationships

    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...
  10. profwannabe

    CF ERROR MESSAGE

    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...
  11. profwannabe

    CF ERROR MESSAGE

    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?
  12. profwannabe

    CFQuery - Whats wrong with my code ??

    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?
  13. profwannabe

    Sorting on results from many-to-many relationships

    ...Biblio (BiblioID, Year, Title, PublisherID) Biblio_Subject_Relationship (BiblioID, SubjectID) Biblio_Author_Relationship (BAID, BiblioID, AuthorID) ** I use an autogenerated PK rather than just the unique combination of the two IDs here because I need to know the order in which authors were...
  14. profwannabe

    CFQuery - Whats wrong with my code ??

    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...
  15. profwannabe

    CFQuery - Whats wrong with my code ??

    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).
  16. profwannabe

    Sorting on results from many-to-many relationships

    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...
  17. profwannabe

    CF Error when using DateFormat In Access

    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!
  18. profwannabe

    templates do not resolve images/picture.gif - Please Help!

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

    CF Error when using DateFormat In Access

    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...
  20. profwannabe

    Embedding parameters within functions

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

Part and Inventory Search

Back
Top