INSERT INTO reg_bikes (SerialNumber, Make, Model, Type, Gears, FrameSize, UniqueID, OwnerName, OwnerAddress, OwnerZip, OwnerPhone, OwnerEmail, OwnerCity, OwnerState, StateStolen, DateStolen, CityStolen, Color1, Color2, Status)
VALUES (
'#FORM.SerialNumber#'
NULL
,
'#Ucase(FORM.Make)##Ucase(Form.MakeOther)#'
NULL
,
'#Ucase(FORM.Model)#'
NULL
,
'#FORM.Type#'
NULL
,
'#FORM.Gears#'
NULL
,
'#FORM.FrameSize#'
NULL
,
'#Ucase(FORM.UniqueID)#'
NULL
,
'#Ucase(FORM.OwnerName)#'
NULL
,
'#Ucase(FORM.OwnerAddress)#'
NULL
,
'#FORM.OwnerZip#'
NULL
,
'#FORM.OwnerPhone#'
NULL
,
'#Ucase(FORM.OwnerEmail)#'
NULL
,
'#Ucase(FORM.OwnerCity)#'
NULL
,
'#FORM.OwnerState#'
NULL
,
'#FORM.StateStolen#'
NULL
,
'#FORM.DateStolen#'
NULL
,
'#Ucase(FORM.CityStolen)#'
NULL
,
'#FORM.Color1#'
NULL
,
'#FORM.Color2#'
NULL
,
'#FORM.Status#'
NULL
)
Thank you for reporting a lost/stolen bicycle on Findmybicycle.com. In the event that we are notified that your bike has been recovered you will be notified via email.
Note: You will be periodically emailed and asked to verify that your report is still current.
Thank You,
Findmybicycle.com
SELECT *
FROM target
A new stolen bike report has been submitted to the database. Here is the information:
Serial Number: #form.SerialNumber#
Make: #form.Make# #form.MakeOther#
Model: #form.Model#
Type: #form.type#
Frame Size: #form.FrameSize#
Number of Speeds: #form.Gears#
Color: #form.Color1#
Secondary Color: #form.Color2#
Owner Name: #form.OwnerName#
Owner Street Address: #form.OwnerAddress#
Owner City: #form.OwnerCity#
Owner Zip: #form.OwnerZip#
Owner State: #form.OwnerState#
Owner Email: #form.OwnerEmail#
Owner Phone: #form.OwnerPhone#
Date Lost/Stolen: #form.DateStolen#
City Lost/Stolen In: #form.CityStolen#
State: #form.StateStolen#
Report A Lost Bike
If your bike has been lost or stolen you can fill out this form to add it to our database. Then if your bike is recovered, you can be identified as the owner and it can be returned. If you have already registered your bike with us and would like to update its status to lost or stolen, please go to the Change Status Page.
Your Information Your personal information will NEVER be displayed on our website and you will NEVER be contacted by anyone except when relating to your report. For more information, please read our Privacy Policy.