Your query is for text strings only (using like), and F8 is defined as a text field (F8=200), like all the other fields, in the DBRW
- change all your data and data formatting in Excel to be text cells
--
_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________
In this case a single user at a time is what we want to that is not a
problem. And Excel is the only thing they are marginally familiar with.
Here is the query. The problem field is F8. Thanks
<%
fp_sQry="SELECT * FROM ""tech_info"" WHERE (F6 LIKE '%ptld%' AND F5 like
'%LIN%' AND (F1 NOT LIKE '%ool%' OR F1 NOT LIKE '%OOL%'))"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=22 align=""LEFT"" width=""100%""> * No tech
listing found </td></tr>"
fp_sDataConn="OR_metro_out"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&F1=200&F2=200&F3=200&F4=200&F5=200&F6=200&F7=200&F8=200&F9=200&F10=200&F11=200&F12=200&F13=200&F14=200&F15=200&F16=200&F17=200&F18=200&F19=200&F20=200&F21=200&F22=200&"
fp_iDisplayCols=22
fp_fCustomQuery=False
BOTID=3
fp_iRegion=BOTID
%>
Stefan B Rusynko said:
Then your query or data column structure is limiting the data to one type
- make the data all one type
- or post you DBRW structure and query and identify the problem field
PS
Excel should not be used as a data source on web sites since it is a single user application
--
_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________
Yes, that is how I set it up and every column displays as it should. But the
column that has a mix of numbers in some rows and letters in others will only
display the numbers on the webpage. The rest of the row is perfect.
Stefan B Rusynko said:
Did you start by setting it up using say
http://support.microsoft.com/default.aspx?scid=268948
--
_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________
I am doing a query to an Excel spreadsheet. The query works fine but one
column is missing some data. It will display numbers but not text. All other
columns in that row will display and the column in question is not even the
field I am keying on. I changed that column properties to text in Excel then
recreated the database connection. But it made no difference. So at this
point I'm not sure if my problem is in Front Page or Excel.
