Recent content by illdill

I finaly found the answer. <%=Replace(FP_FieldVal(fp_rs,"myMemoFieldName" ),chr(10)," <br>" )%> This code replaces the column value code at the end of the line for the particular result at issue. Where the original <%FP_Field( code starts to the end of the next webbot segment -->

That doesn't work, it shows up in the text and if I use the   it disappears from the text after I submit it.

I can't seem to figure out how to preserve the paragraphs when displaying values from a memo data field. When I pull up the record to edit it in my form, the paragraphs are there, but when it displays in the FP DRW they are gone, and the memo is one big paragraph. Any ideas? Thanks Example...

Nevermind I turned on DEBUG and it was an s-columns error. I havn't had that since upgrading to 2003 until now. Weird... I was able to get it to take by changing the :: to %% even though it changes it back.

Using FP2003 against ACCESS UPDATE registration SET regName='::regName::', regType='::regType::', specEvent='::specEvent::', friDinner='::friDinner::', satDinner='::satDinner::', vegetarianCouples='::vegetarianCouples::', vegetarian='::vegetarian::', specialReq='::specialReq::' WHERE...

I am using FrontPage/ASP/Access How can I embed a word file in a form and more importantly, have it save to an access database. I have a field called docfile that is set to the ole object data type. Thanks. This is a tough one, I have been searching my heart out, but the closest I came was...

In FrontPage, ::imgwhoorwhat:: represents a form field (text data type). % at each end represents wild cards. I tried using only one % wild card but I still get no results.

I have two different search forms, one is meant to find books only, the other to find media. So for the media form there is only one extra field. For some reason, with this extra field, I get no results... Query for books (works fine) SELECT * FROM SearchActive Where title LIKE '%::title::%'...

That did it! Thanks! :)

I have two titles 'War and Peace' and 'Peace and Love'. When I search for 'Peace' I only get the 'Peace and Love' title, but not the 'War and Peace' title... SELECT * FROM SearchActive Where title LIKE '::title::%' AND author LIKE '::author::%' AND subject LIKE '::subject::%' Thanks

After I realized I was working against two different forms (which is why I wasn't seeing the changes) I was able to get it working. I used now()-30 as a parameter in an Access query along with the Mod2 against the ID. You can see the results here: http://illdill.org/Atheists/News/results.asp...

http://illdill.org/Atheists/News/result1.jpg Here is the link showing the new query wich makes me wonder if the resultsw are not reflecting the changes as well as I have included this image on the results page and it is not loading... just the same results... Thanks for the CDate....

Well, thanks for your help, what is CDate..?

Odd.. I included a screenshot of the query in FP and the results page is not reflecting it...

Ok, have the recent query in effect, but am producing no different results..